I just made a spreadsheet and i have formuals in certain rows i do not want to have changed. I understand to protect things i have to protect the sheet. But becasue some people will be needed to make changes to different variables i need to have certain cells "unlocked" so that they can go in and freely input there info on a weekly basis but not have the ability to delete the forumlas i wish to have locked in.
Can anyone help me please.
Time is of the essence.
Im handing the reigns over on monday.....
Thanks for any and all help.
Page 1 of 1
Excel Cell Protection. only certain cells.
#2
Posted 27 June 2008 - 01:45 PM
Protect the entire sheet. Then unprotect cells you allow to change.
#3
Posted 27 June 2008 - 04:39 PM
Yea ifigured thats what i have to do. but when i go to format those cells to unprotect it its not letting me choose the format feature?
Am i missing something. I password protected it when i protected it. Does that have something ot do with it.
I think im missing something
Am i missing something. I password protected it when i protected it. Does that have something ot do with it.
I think im missing something
#4
Posted 01 July 2008 - 06:21 PM
I'm not sure I understand what you wrote.
Once a cell is protected, none of the editing functions work, be it editing values, formats, column widths etc, most menu items are disabled.
If you're trying to unprotect a protected cell, I'd think reversing the process would work - unprotect the sheet, edit, reprotect again for the cells you need.
Once a cell is protected, none of the editing functions work, be it editing values, formats, column widths etc, most menu items are disabled.
If you're trying to unprotect a protected cell, I'd think reversing the process would work - unprotect the sheet, edit, reprotect again for the cells you need.
Share this topic:
Page 1 of 1

Help


Back to top








