Forum Discussion

Pmuts's avatar
Pmuts
Copper Contributor
Jun 22, 2019

Protecting cells in EXCEL

I have created a spreadsheet for others to use with complicated manipulation and formulae. My desire is to protect the part of the cells so things can't be changed and leave the rest for user input. ...
excel
nabilmourad's avatar
nabilmourad
MVP
Jun 24, 2019

Pmuts 

Just an extra tip to the excellent replies already mentioned,

The concept of protection in Excel is reversed, which means, when you click on Protect Sheet on the Review Tab (read the wording) it says "Protect Sheet and content of locked Cells."

By default the 17,179,869 cells in any sheet are locked >> so all of them become protected. 

So when I said the concept is reversed, I mean in Excel you specify what Not to protect by going to the Format Cell dialog Box CTRL + 1 >> Protection Tab >> uncheck Locked for the cell where you want to enable editing.

Thanks

Nabil Mourad

  • Gae365's avatar
    Gae365
    Copper Contributor
    Sep 13, 2019

    nabilmourad 

    Hi, thanks for your suggestions. I've another question: 

    I've created several excel worksheets in various workbooks and I need to lock just some cells with specific formats (e.g. only cells in green for all the sheets and workbooks I created).

     

    Do you know a quick way / method to lock all such cells thanks to their specific format?

     

    thank you,

     

    Gaetano 

Resources