Hide formulas and protect workbooks

Hi Kat

Thank you for your question.

You can hide a formula by first right clicking on the cell that contains the formula. Then from the context menu choose Format Cells > Protection > then make sure the Hidden tick box is selected.

Now when you turn on protection (Review tab > Protect Sheet) the results will be visible however the formula will no longer be displayed in the formula bar.

You can also use Protect Workbook to prevent sheets from being added or deleted.

This level of protection does not encrypt hidden sheets - be cautious if your document contains sensitive information, even if it is set to be hidden. Users may still be able to view the contents.

Lastly you can protect your entire document with a password to only allow access to approved users. To set a password on your workbook click on File then Info > Protect Workbook. From the list that appears choose Encrypt with password.

You may find the following articles on the Microsoft website helpful


http://office.microsoft.com/en-us/excel-help/password-protect-worksheet-or-workbook-elements-HP010342808.aspx?CTT=1


http://office.microsoft.com/en-us/word-help/protect-your-document-workbook-or-presentation-with-passwords-permission-and-other-restrictions-HA010354324.aspx

I hope this helps - let me know how you get on.

Kind regards,
Andrew