need to print "formula" in cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello, I need help on how to for instance: Cell A1 contains the formula
=Sum(B12+D15). The calculated answer is in cell A1 but I would like to
actually print the "formula" that you don't see. My worksheet is full of
these formulas and I wish to have a printout to have a hard copy of them
should my file become corrupted or crash. I appreciate your advice! Thanks!
Frank :-)
 
Frank,

Select Tools Options. Then, click on the View tab and check the box
"Formulas" in the Window Options section at the bottom of the dialog box.

The shortcut key for this is CTRL + ~ (tilde)

Stan Scott
New York City
 
Frank

You have an answer which will do the trick, but kinda messy.

For neater layout I would suggest John Walkenbach's ListFormulas code from

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

Lists formulas, addresses and results on a separate worksheet.

Or David McRitchie's GetFormula Function from

http://www.mvps.org/dmcritchie/excel/formula.htm#getformulainfo

They both involve the use of VBA. If new to VBA and Macros see David's site
for Getting Started with VBA and Macros.

http://www.mvps.org/dmcritchie/excel/getstarted.htm

Gord Dibben Excel MVP
 
Back
Top