Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training course - Protecting a sheet
excel training course - Protecting a sheet
Resolved · Low Priority · Version Standard
Protecting a sheet
how do i make sure i've protected all the formulas on a large and complex sheet to make sure that it can't be changed?For upcoming training course dates see: Pricing & availability
RE: Protecting a sheet
Hi Rosa,To protect your data you can either password protect the whole document or partially protect the sheet to protect the formulas. I suggest to make sure you have protected the cells or indeeed the document try and see whether you can change it!
Protect the sheet
Once in the document, go to "save as" once in the dialog box use the Tools menu and go down to the general option and enter in your password.
Partially protect the sheet
Highlight the cells you want to be available to others, go into the format menu and across to the Protection tab and unlock those cells.
Then go to the Tools menu and down to Protection to protect the sheet. This will allow access to the first set of cells but not to others.
Hope this helps
Tracy
|
|
» Forum post: Sound Clips |



Course updates

