How to password protect cells in excel 2010

#HOW TO PASSWORD PROTECT CELLS IN EXCEL 2010 HOW TO#

To do this, you have to first lock the target cells and then protect them to complete the locking process. By locking the cells, others users can read the file data but cannot make the changes in locked cells. Once they are locked, the cells become un-editable. This goal can be achieved by locking the target cells. Sometimes, we want to restrict the users from making changes to some specific or all cells. This chapter will describe to you how one can unlock the cells.

To make the cells again editable, we have to unlock the locked and protected cells. Only then, you can manipulate the cell's data. Hence, if you want to modify any of the content or changes something in the locked cells, they need to be unlocked. It means that we lock the cells to keep the data secure from being altered by anyone. The cells need to be locked for the security reasons of data. Locked cells cannot be altered and no one can their content until they are unlocked. In Excel, when cells are locked and protected, they are not editable.

#HOW TO PASSWORD PROTECT CELLS IN EXCEL 2010 HOW TO#

Using the protection features of Excel makes it more difficult, but a determined user may be able to still view the contents in the described manner.Next в†’ в†ђ prev How to unlock cells in Excel? The bottom line is that it is virtually impossible to 100% protect the contents of the column so that they cannot be viewed. The contents of the locked and hidden cell are pasted in the unlocked cell. Use F5 to jump to the locked and hidden cell, then press Ctrl+C, move to the unlocked cell, and press Ctrl+V.

Copy the contents of the locked and hidden cell and paste it in the unlocked cell.

For instance, if column E is locked and hidden, entering the formula =E3 will display, in the unlocked cell, the value in cell E3.

In the unlocked cell, enter a formula that references a locked and hidden cell.

There is one caveat to all this: If you have some cells in the worksheet (or workbook) that are unlocked, so that the contents of the cell can be changed, it is still possible to see what is in individual cells of the column. You are prompted to reenter your password (the one from step 9), which you should do.ДЄt this point someone cannot view what is in the hidden column, even if they use F5 to jump to one of the cells in the column it still won't appear in the formula bar. (These two options are selected by default in a worksheet.) At a minimum you should choose Select Locked Cells and Select Unlocked Cells.

Using the check boxes, select what type of protection you want applied to the worksheet.

Enter a password to be used in protecting the worksheet.

Excel displays the Protect Sheet dialog box.

Again, starting in the Cells group, click Format | Protect Sheet.

Starting in the Cells group, click Format | Hide & Unhide | Hide Columns.

With the column still selected, display the Home tab of the ribbon.

(It is the Hidden check box that controls whether the cell contents are visible in the formula bar or not.)

Make sure both the Locked and Hidden check boxes are selected.

The Protection tab of the Format Cells dialog box.

Make sure the Protection tab is displayed.

Excel displays the Format Cells dialog box. Since you already know how to protect a worksheet, you are already on your way to accomplishing your task. He knows how to protect the worksheet and how to hide data in cells but noticed that info is still visible in the formula bar. He wants to hide some of the columns in the worksheet, however, so that they cannot be viewed by users.

Roger has a worksheet that he needs to distribute to different people so they can add and change some information.

How to password protect cells in excel 2010