print formulas

[here]

in excel 97, i cant find ANY info in knowledge base to print the formulas
out.
any ideas?
thanks
mike

 

[A.W.J. Ales]

here,

Either : <CNTRL> + ` ( key with ~) or Tools / Options / View tab / and
Change setting of Formulas checkbox in the windows options part will bring
you in or out the "formula mode" of Excel.
In "formula mode" you could print the formula's, but as you can see it's
layout has to be set carefully as the width of the columns are not anything
like Excel's "normal mode" and they actually can be very large. I suggest
you look carefully what to print befoer actually starting it.

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *

 

[here]

thanks very much. i couldnt get the formula to wrap within the cell but i
got what i needed

 

[David McRitchie]

The width of the columns for the formula view is exactly 3 times
the normal width of the column. If you change the wideth in the
formula view then you will be also changing the width of the column
in the normal view. You might want to copy the worksheet to another
sheet if you want to adjust columns and then print.

What I like to do is to display the formulas of one column or to
display some representative formulas, very seldom would I need
to display or print all of the formulas -- in fact I would say I never to
see all fo the formulas. For information on displaying the formula
used in another cell see GetFormula and GetFormulaD in
http://www.mvps.org/dmcritchie/excel/formula.htm
i.e. =GetFormula(B3)
The advantage is that you get the see the actual working formula right
on the same page at the same time as you look at the actual spreadsheet.

Some other means of printing all of the formula on a worksheet can
be found in John Walkenbach's (it's referenced on my formula.htm page)
Creating a List of Formulas (Tip 37)
http://j-walk.com/ss/excel/tips/tip37.htm
which I believe will print the cell address, value, formula

 

[David McRitchie]

My mistake the formula view column widths are exactly 2 times the
column width in the normal view. I hope the rest of the information
provided is correct.

 

[Ken Wright]

And whilst definitely a bit kludgy, as a quick print method for a bunch of
formulas, you can always use the watch window, then ALT+PRINTSCREEN it to
Powerpoint. I prefer that view to the View / Formulas one as it groups them
nice and neatly and allows you to sort them by Book / Sheet / Name / Cell /
Value / Formulas.