display formulas

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

Guest

Is there a way to print your spreadsheet so that your formulas appear in the
cells, rather than the answers
 
Hi Dianne,
Is there a way to print your spreadsheet so that your formulas appear in the
cells, rather than the answers
Click to expand...

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
 
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
 
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
 
Back
Top