Karen has attended:
Excel Advanced course
Permissions
How can I allow access to a document but only allow people to make basic changes without changing any formulas? Do I have to protect each cell or can I set something for the whole document?
Thanks
RE: Permissions
Hello Karen
Thank you for your question and welcome to the forum.
You can apply protection to a whole worksheet, however if you would like people to still be able to change the data in certain cells on the sheet, then you will need to unlock these cells first before applying protection to the worksheet.
To unlock cells:
1. Select the cells that you want people to be able to edit/change.
2. Go to Format-Cells, Protection tab, and unchecked the Locked checkbox. Click OK.
To apply protection:
1. Go to Tools - Protection - Protect Sheet.
2. Set a password if you wish (this means people will have to know the password to remove the protection and thereby be able to change any cell in the spreadsheet).
Once the protection is applied, you should only be able to edit the cells that have been unlocked.
I hope this helps.
Kind regards
Amanda