display formulas

[Dianne from Canada]

Is there a way to print your spreadsheet so that your formulas appear in the
cells, rather than the answers

 

[Jan Karel Pieterse]

Hi Dianne,

Is there a way to print your spreadsheet so that your formulas appear in the
cells, rather than the answers

Tools, options, view tab, check "Formula´s"

Keyboard shortcut to toggle this: control-shift' (above your tab key)

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com

 

[Paul B]

Dianne, in addition to Jan's answer, if you want to creates a list of all
formulas and their current values have a look here
http://j-walk.com/ss/excel/tips/tip37.htm
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2003

 

[David McRitchie]

Another option would be to just display some representative formulas
or add a couple more columns to show the formulas used in
two of the original columns. The advantage is that you get to
see both the values in place and the formulas in a location
nearby. The user defined functions (UDF) of main interest
would be GetFormula and GetFormulaD
Show FORMULA or FORMAT of another cell
http://www.mvps.org/dmcritchie/excel/formula.htm

If not familiar with installing macros (and/or UDF) see
http://www.mvps.org/dmcritchie/excel/getstarted.htm