Excel+protect+cells+with+formulae+on

Excel protect cells with formulae on

Protect selective cells in a worksheet (the ones that contain formulas) from accidentally being altered or deleted?

By default, all Excel worksheet cells have locked definitions associated to them.

However, it has no effect unless the worksheet is protected.

This function will take effect only if the worksheet has been protected, and it covers all cells in the protected worksheet or workbook.

If you want to protect only specific cells, such as those with formulas, you would first need to unlock all the cells on the worksheet, lock the cells that you want to protect, and protect the worksheet.

The procedure is as follows :‐

1. Select all of the worksheet (hold down the Ctrl and “ A “ ) ,

Or all of the working cells in your sheet (By holding down the Ctrl, then select the individual Cells by clicking on them until all are selected).

2. When the selection has been made, right‐click the mouse and select Format Cells from the dropdown window.

3. Click the Protection tab, deselect (i.e. un tick in the box ) the Locked check box, and click OK

4. Now click the specific cells that you want to protect.

You can select them all at once by holding down the Ctrl button on your keyboard while you click each cell.

5. Once all cells are selected, right‐click the mouse again >

Go to :‐

Format Cells, click the Protection tab, and this time select the Locked check box and click. OK

6. The final stage is to protect the worksheet:‐

Click Tools, go down the menu to Protection, click Protect Sheet, then click OK

A password is optional here. If you want to password‐protect it, enter a password (you will need to

re‐enter it to confirm), then click. OK

Donʹt forget your password because there is no way to retrieve it.

7. Save your work!!

Now your worksheet is protected, and locked cells cannot be tampered with

If later you require to unprotect the cells in order to modify or whatever

Follow step 6 to Unprotect sheet or open it with the protection password you assigned to it, and

hopefully remembered, or found the note