Protected worksheet

  • Thread starter Thread starter Michelle
  • Start date Start date
M

Michelle

I have a spreadsheet that is protected so that nobody can
change anything (all of the cells in the spreadsheet are
protected), except for me. I did this by adding myself
in the Allow Users to Edit Ranges, under permissions.
This has worked perfectly, except for when I try to drag
any values down to other cells. It then gives me a
message saying that I can't change part of a protected
cell. What should I do to be able to drag
formulas/values down in my protected worksheet?
 
Back
Top