Protecting all the cells except three

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!!!
 
K

Ken Wright

Select your 3 cells - Then Format / Cells / Protection / Untick 'locked'. Now
do Tools / Protection / Protect Sheet.
 
P

Pete JM

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
Click to expand...
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
 
Top