After locking the cells, the worksheet needs to be protected to lock the cells from being edited. Then we will select the formula cells and lock them. For that, we need to change the default setting of all the cells in the sheet (which is locked) to unlocked. Locking formula cells means that we will be locking some chosen cells. Next, the sheet has to be protected to lock the cells from being changed. Then the specific cells can be selected and locked. To lock certain cells on a worksheet, all cells must be unlocked first. This means that both cell locking and hiding need sheet protection to work. Hidden cells also need sheet protection to hide the contents of the cells. The locked cells however are only truly locked from editing once the worksheet is protected. This may come as a surprise but all cells are locked by default in Excel. Step 2 – Lock the Cells in the Worksheet Containing the Formulas.Step 1 – Unlock all the Cells in the Worksheet.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |