Protecting all the cells except three

  • Thread starter Thread starter iguzman
  • Start date Start date
I

iguzman

I need to protect all the cells in a worksheet from deleting, changin
numbers, colors, etc. Except three cells that need to be changing al
the days of this same worksheet, how i can do it?

Thanks in advance!!!
 
Select your 3 cells - Then Format / Cells / Protection / Untick 'locked'. Now
do Tools / Protection / Protect Sheet.
 
Select the three cells that you don't want protecting then go to Forma
Cells Select the Protection tab and click on the box next to locke
to remove the tick.

When done click OK

Next go to Tools > Protection > Protect Sheet.

All the cells will be protected apart from the three you wanted.

Pet
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top