keep specific cells from being changed.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I keep following the instructions to lock only specific cells but the entire
worksheet is locked. Here's exactly what I'm doing: 1. I unlock the entire
sheet. 2. select subset cells. 3. format>cells>protection>click locked 4.
Tools>protection> protect sheet, but it's forceing me to click both unlocked
and locked cells in the next dialog box. what am I doing wrong?
 
I keep following the instructions to lock only specific cells but the
entire worksheet is locked. Here's exactly what I'm doing: 1. I unlock
the entire sheet. 2. select subset cells. 3.
format>cells>protection>click locked 4. Tools>protection> protect
sheet, but it's forceing me to click both unlocked and locked cells in
the next dialog box. what am I doing wrong?
Click to expand...

You should first not lock (untick the protection box for) the cells that
are to remain editable and then lock the sheet.
 
Back
Top