protecting only a few cells????

  • Thread starter Thread starter frens
  • Start date Start date
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
 
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
 
Back
Top