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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |