To edit these cells, you have to unprotect the sheet. Note: if you also check the Hidden check box, users cannot see the formula in the formula bar when they select cell A2, B2, C2 or D2.Īll formula cells are locked now. On the Protection tab, check the Locked check box and click OK. On the Home tab, in the Editing group, click Find & Select.Ĩ. To lock all cells that contain formulas, first unlock all cells. The password for the downloadable Excel file is “easy”.
:max_bytes(150000):strip_icc()/011-how-to-add-up-columns-or-ros-of-numbers-in-open-office-calc-c25400211be445ac8dd930804c02f4b3.jpg "how to lock cells in openoffice excel")
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. 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).ģ. However, locking cells has no effect until you protect the worksheet.Ģ. Lock All Cellsīy default, all cells are locked. You can lock cells in Excel if you want to protect cells from being edited. Lock All Cells | Lock Specific Cells | Lock Formula Cells
0 kommentar(er)
