Excel: showing/printing formulas

R

RG

Hi! Where can I change the cells to show the formulas (rather than the result of the equation) Thx.
 
C

Chip Pearson

RG,

You can go to the Tools menu, Options, then the View tab. There,
check the "Formulas" option. Or you can use the keyboard
shortcut, CTRL+`


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


RG said:
Hi! Where can I change the cells to show the formulas (rather
Click to expand...
than the result of the equation) Thx.
 
D

David McRitchie

Rather than toggling between the formula view and the normal view,
I generally prefer to show the formula(s) that I am interested in with a
user defined function so I can see the formula actually in use at the
same time as the results. See GetFormula and GetFormulaD
user defined functions at the top of
http://www.mvps.org/dmcritchie/excel/formula.htm

Disadvantage of toggling to the formula view -- you don't see
formula and result at same time and the formula view column width
will probably be inadequate -- the column width is doubled to
help you see the formulas.

Disadvantage of a separate listing, you basically have to print it,
it may be a long list,
and it will probably not be current as you probably went through the
steps of creating the list in order to correct some formulas.
 
Top