A Simple Computer Library

Protect and hide formulas

Select cell(s) whose formulas you want to hide using Format menu.
Click Cells and then click the Protection tab.
Click Hidden and click OK.
Click Tools menu, Protection, Protect Sheet.
Type password and click OK.
Reenter password to confirm, then click OK.
..
The step to remove protection:
Click Tools menu, Protection, Unprotect Sheet.
Type password and click OK.

This entry was posted on Monday, June 4th, 2007 at 6:59 am and is filed under Microsoft Excel. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.