Printing formulas in a spreadsheet

[Susan Furjanic]

How can I print the formulas in a worksheet??




Thanks,

 

[Paul B]

Susan, here is one way, Ctrl+`

 

[David McRitchie]

If you mean how to show the formula used in another cell see
the GetFormula macro in
http://www.mvps.org/dmcritchie/excel/formula.htm
other solutions are in the related area at the bottom of the page such
as on John Walkenbach's pages.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

 

[tel]

Select Tools, Options and click the formulas box

If you mean how to show the formula used in another cell see
the GetFormula macro in
http://www.mvps.org/dmcritchie/excel/formula.htm
other solutions are in the related area at the bottom of the page such
as on John Walkenbach's pages.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Susan, here is one way, Ctrl+`