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?

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
 

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