top of page

Hiding Formulas

Tonight's tip is very simple. If you want to hide formulas in an Excel workbooks, take these steps:

1. In this example, we have a formula entered in column P.

2. Select column P, and then go to Home . . . Format . . . Format Cells

3. In the dialog box on the Protection tab, check off 'Hidden'.

4. As the note in the dialog box indicates in order for the change to take effect you then have to go to Review . . . Protect Worksheet and enter a password.

The formulas which are still present in column P will not be displayed in the formula bar.

bottom of page