I have a spreadsheet for others to fill in some fields but I do not want them to be able to change or erase certain cells especially ones that I have formulas. Can I do this?
Select all the cells on the worksheet that you do want to allow editing in.
(One easy way is to hold the Ctrl key down and keep selecting them
with your mouse).
Then choose Format/Cells/Protection and uncheck the Locked" box.
Now protect the sheet (password optional)
Tools/Protection/Protect Sheet.
John
Michael said:
I have a spreadsheet for others to fill in some fields but I do not want
