protect a single row of formulas

  • Thread starter Thread starter dalstar
  • Start date Start date
D

dalstar

how do I protect a single row or group of rows (or columns) without
protecting the entire sheet. I have tried everything that I can think of
but nothing works. I have a spreadsheet that tracks labor hours. I have
several rows and columns I need protected, leaving areas for data entry.
 
Hi

basically, you need to "unlock" the bits you want people to get to (format /
cell / protection and untick the locked check box) and then protect the
sheet (tools / protection / protect sheet).
 
Thanks for the response. Is there anything else that needs to be done
(refresh or something)? I have tried your suggestion several times and I am
still able to go into the cell I wanted protected and overwrite the formula.

jm
 
Hi

you might need to check that the cell you want to LOCK has the "locked"
value ticked in format / cells / protection.
 

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

Protect Formulas while deleting rows 1
hide, unhide column or row after protect worksheet 4
Protect Hidden Columns and Rows 1
how do I insert row keeping formulas from previous row? 1
Protect 2
Can't use protection options 1
Macro to insert a row and copy down formulas from row above 2
Auto fit text in cell of a protected worksheet 3

Back
Top