Unlocking the rows and columns of excel follows the same rule. Enter the password that you gave while protecting the cells. Just click on the Review option on top, click on the Unprotect Sheet. Unlocking the cells in excel is much easier. The rest procedure is the same as before. By clicking them on we can select the entire row or column. For columns a downward arrow and for the row, a rightward arrow will come up. For locking rows and columns just move the mouse courser to the row heading or column heading.After this whenever you want to edit the desired cells of the excel you will see a warning box indicating that you can not edit the cells as it is protected.Another dialogue box of Confirm Password will come up. Select the password on Password to unprotect the sheet. Tick on Select locked Cells and Select unlocked cells. After clicking on the Review option on top, click on the Protect Sheet option.After the Format cells window opens, press on the Protection option, and click on the Locked option.After selecting the cells, press the right-click button of the mouse.First, we will need to select the cells we want to lock.Read Moreā¦ How to lock certain cells in Excel
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |