How to Protect Formula in Worksheet in Spreadsheets 2013

Sometimes you will need to protect certain cells in your spreadsheet which has formulas, to avoid accidental changes but allow editing of other data cells. You can set a password to protect only the locked cells but allow users to select and edit unlocked cells. Follow these steps:

Protect sheet formula

Step 1 Open the workbook you want to protect.

Step 2 Select the cell range you want to protect.

Step 3 Right click on the selected cells, and click on Format Cells in the context menu. See following:

Step 4 In the Format Cells dialog box, go to Protection tab and select the two check boxes of Locked andHidden. Then press OK. See following:

Step 5 Go to Review tab and click Protect Sheet button. It will ask you to enter password (optional) to protect the sheet. In the option list, select Allow all users of this worksheet to: Select unlocked cells.

Step 6 Press OK to finish setting.

In this way, you will find that the cells which are protected could not be selected, but others can be selected and edited.

Unprotect Sheet

In case you want to edit formulas in the workbook, you need to enter password to unprotect the worksheet.

To cancel protection of the sheet, simply go to Review tab, and click Unprotect Sheet.

You need to enter the protection password in the pop-up box to cancel protection.