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?
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?

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).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top