Forum Discussion
Excel
I am trying to unlock cells in my spreadsheet. Need assistance to do this function. thanks
Hello,
In addition, if you're keyboard-savvy, you can:
1. Press CTRL + 1 to open the Format Cells dialogue box.
2. Click on Protection tab
3. Uncheck Locked box
Then, if you intend to protect Sheet:
4. In the Protect group of the Review tab, click on Protect Sheet
5. If you dont need password to protect, uncheck Select locked cells
6. Click OK
See attached pictures
In addition, if you're keyboard-savvy, you can:
1. Press CTRL + 1 to open the Format Cells dialogue box.
2. Click on Protection tab
3. Uncheck Locked box
Then, if you intend to protect Sheet:
4. In the Protect group of the Review tab, click on Protect Sheet
5. If you dont need password to protect, uncheck Select locked cells
6. Click OK
See attached pictures
