Hiding Formulas

Hiding Formulas

December 24, 2018

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. 

 

 

 

 

 

Please reload

Contact Me With Your Litigation Support Questions:

seankevinoshea@hotmail.com

  • Twitter Long Shadow

© 2015 by Sean O'Shea . Proudly created with Wix.com