excel training course - 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