Diamond Pokemon Deluge

Protect Cells and Sheets in Excel

Let's see how they can protect cells and sheets in excel.

1. To protect an entire sheet of a book (file) excel, we just go directly to the menu Tools / Protect / Protect Sheet :

following window opens:

The options are selected by default are " Select locked cells , allowing us to place ourselves in that we protect the cells but does not allow us to make any changes to them, and" select unlocked cells "that will allow us to situate and modify those cells that do not protect them. The list of actions you can perform in spite of that we protect the cells are, as you can see in the image window, many more (change formatting cells, rows, columns, etc.) ..

2. If you wish to enter a password to turn off the protection then we write in the " Password to unprotect sheet ."

3. Press OK after selecting the desired options and that's it. If you then try to write or delete any content of any cell, Excel will not let us and we will display a message like the following:

When we do things well in Excel, protect individual cells is very simple. I mean the use of Input-Output Model Data . To protect individual cells of a sheet must follow the following steps:

A) Select the cells you DO NOT want to protect, ie the data entries.

B) Go to the menu Format / Cells and select the last tab in the window:

C) Disable Blocked and click OK . Returning to the road has not yet happened. If you try to write in cells, for example, will contain formulas that can be done without problem.

D) Go to the menu Tools / Protect / Protect Sheet and click directly OK. From this moment you can only modify the data entry cells, while their formulas and other empty cells can not be modified.

Tip

In many cases the data inputs are numerous and are scattered throughout different parts of the leaf. Select one to one can be a tedious job. It's time to use the Edit menu / Ir a. .. and press the button, the window that appears, Special . Excel will present the next window, where we select the Constants option (refers to cells containing but not formulas):

Al click OK excel all our cells will be selected for data entry (and we could proceed from step B to protect specific cells).