This is a great for preventing people from editing formulas.
Note: if you don't check any action, users can only view the Excel file 6. Google Sheets allows you to protect cells or sheets so that certain users cannot edit them. To do this, select the Review tab from the toolbar at the top of the screen. For the locking of the cells to take effect, you must also protect the worksheet.
The password for the downloadable Excel file is "easy". Check the actions you allow the users of your worksheet to perform. When the Format Cells window appears, select the Protection tab. To edit these cells, you have to unprotect the sheet. With the required cells selected, press Ctrl + 1 to open the Format Cells dialog (or right-click the selected cells and click Format Cells ), switch to the Protection tab, and check the Locked checkbox. On the Protection tab, check the Locked check box and click OK.Īgain, locking cells has no effect until you protect the worksheet.Ĭell A1 and cell A2 are locked now. Right click, and then click Format Cells (or press CTRL + 1).Ħ. For example, select cell A1 and cell A2.ĥ. On the Protection tab, uncheck the Locked check box and click OK.Ĥ. To lock specific cells in Excel, first unlock all cells. The password for the downloadable Excel file is "easy". To unprotect a worksheet, right click on the worksheet tab and click Unprotect Sheet. On the Protection tab, you can verify that all cells are locked by default.Īll cells are locked now. Right click, and then click Format Cells (or press CTRL + 1).ģ.