How do I print cell formulas out.

R

Rick

Prof at college wants the spreadsheet and a listing of all
the formulas used. He says there is a way to do this in
Excel 2000. I don;t see it...

Mudd
 
G

gary brown

Tools / Options / Window Options / check FORMULAS
Now everything is a formula. Print it, then go back and
upcheck the FORMULAS box.
HTH,
Gary Brown
 
D

David McRitchie

Hi Rick,
The formula view is not really very good for printing formulas, as
the formula view has the columns just a little over 2 X the wide
of the normal view.

I generally find that I only need a few representative formulas
and would use GetFormula or GetFormulaD user defined function in
http://www.mvps.org/dmcritchie/excel/formula.htm

If you really want to list all of the formulas, it would be better to
include the cell address, values, formulas, and displayed text
alongside each other. See
John Walkenbach's Creating a List of Formulas (Tip 37)
http://j-walk.com/ss/excel/tips/tip37.htm
 
Top