Is there a why to show the cell formulas to print?

S

Sheryl Stewart

I have been trying to print off the sheet that I am using to check the
formulas myself. I know there is a way to do this but can't seem to remember
how.

Thanks

Sheryl
 
J

JE McGimpsey

Type CTRL-` (accent grave, on the key above the Tab key on standard US
keyboards) to display formulas.
 
G

Gord Dibben

John's suggestion is one method but doesn't isolate just the formulas.

I like John Walkenbach's ListFormulas macro.

Places the formulas, results and addresses on a new sheet for printing.

http://www.j-walk.com/ss/excel/tips/tip37.htm

Makes for a nice printout.


Gord Dibben MS Excel MVP

On Thu, 22 Feb 2007 13:55:41 -0800, Sheryl Stewart <Sheryl
 
Top