protecting only a few cells????

F

frens

Hello,

Excel wants me to define which cells I do NOT want to block for input.
I want to select a few cells and tell Excel to lock only these, since
entered data that I want to protect.

How to
 
P

Peter Andrews

frens said:
Hello,

Excel wants me to define which cells I do NOT want to block for input.
I want to select a few cells and tell Excel to lock only these, since I
entered data that I want to protect.

How to?
Click to expand...

Select entire sheet ^A (Control A) select format, cells, uncheck lock, then
select the cells you want protected and check lock. Takes less than 20
seconds to do. But don't forget to protect sheet when finished.

Peter
 
Top