How do I print cell formulas out.

[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

 

[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

 

[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