Protect Only Certain Cells

  • Thread starter Thread starter bgcooker
  • Start date Start date
B

bgcooker

How do I protect only certain cells rather than the entire worksheet? I have
a range of cells with formulas that I do not want the users to be able to
accidentally delete or change. I can protect the entire sheet, but cannot
figure out how to protect ranges of cells.
 
Select the whole sheet by clicking the box on the top left, (to the left of
A and above 1). Right click anywhere in the sheet, click 'Format Cells',
Protection tab and uncheck 'Locked', OK
Now select the cells you want to protect, (hold down Ctrl and select them
one by one), right click in one of them and go to Format Cells, Protection
again, check 'Locked', OK. This means that only the cells you selected will
be protected, not all of them which is the default.
Now protect the sheet,
Regards,
Alan.
 
Highlight the range(s) of cells that are for input data (ie. unprotected) -
then select Format...Cells....Protection and uncheck the "Locked" box
("Locked" cells being default setting). You can then protect the sheet and
remaining cells will be locked.

I find it useful to highlight only input areas by using colour formatting.
 

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

Similar Threads

Cell Protection? 2
Protecting a Sheet 7
Protect/Restrict usage of a range of cells. 2
Protecting select cells 2
Code to format cells on several worksheets 2
Protected Worksheet Tab Order 1
Hiding Formulas and Being Able to Make Changes 2
How do I set up worksheet to keep tabs from being deleted? 1

Back
Top