Forum Discussion

maria2020's avatar
maria2020
Copper Contributor
Jan 01, 2020

Excel

I am trying to unlock cells in my spreadsheet.  Need assistance to do this function.  thanks

 

excel

4 Replies

  • Abiola1's avatar
    Abiola1
    MVP
    Jan 03, 2020
    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
  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Jan 03, 2020
    Select the cells, right-click in the selected area and choose Format Cells. On the last tab of that dialog uncheck the Locked box.

Resources