printing extensive formulas in Excel 2004

C

chickieram

Version: 2004
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

How can I print the formula which is very extensive?
 
B

Bob Greenblatt

Version: 2004
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

How can I print the formula which is very extensive?
Click to expand...
You can do several things. 1)Switch to formula display through the
preferences, or pressing CTRL ` (That's the key next to 1). Then adjust
column widths and or row heights to show the formula, then print. Or 2) copy
the formula text from the formula bar, and paste it into WORD or other text
editor and then print that. You'll have to do this one cell at a time, and
note the cell ID along with the formula text.
 
J

JE McGimpsey

Version: 2004
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

How can I print the formula which is very extensive?
Click to expand...

If it's only one (or a small number) of extensive formulae, put an
apostrophe (') in front of the "=" sign(s).

Print, then remove the apostrophe(s).
 
Top