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
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.
