MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Viewing all the formulas in a Worksheet - self documenting

Posted by Kevin on January 11, 2001 10:45 PM

I have a very large workbook that has a mixture of formulas and macros all over it. Unfortunately the person who created the workbook has left the company and there is no documentation. Is there a way to display just the formulas not the values in the cells? Or is there a product that will document the code in the program and make a map of the worksheet for me?

Posted by Dave Hawley on January 12, 2001 1:24 AM

Hi Kevin

Go to Tools>Options/View and select the "Formulas" box.

OzGrid Business Applications

Posted by Mark W. on January 12, 2001 5:57 AM

Use Ctrl+` or choose the Tools Options menu command
to check the Window Options Formulas checkbox on
the View tab.

Posted by Kevin on January 12, 2001 8:00 PM

Thanks, forgot about that one...