Excel formula printing
 

I'm trying to balance two different worksheets. I want to print the formula
from one cell in Worksheet A so I can check it against Worksheet B. When I
follow all the directions it only prints 1/2 of the formula (it's a very long
formula).

Is there any way to get it all printed without doing a screen print?

An idea: click on the formula bar, highlight the entire formula, and
press CTRL-C to copy the formula into the clipboard. Then open MS Word
and press CTRL-V to paste. This will allow you to print the entire
formula.

As an alternative, if the formulas are _very_ similar and you want to
compare them character by character, copy the formulas to the clipboard
but this time paste them into Notepad. Notepad is a very handy, very
rudimentary text editor that does not perform a word wrap, so the
formula will be written out in its entirety with no line breaks.

Hi Dave,

Notepad is a very handy, very
rudimentary text editor that does not perform a word wrap

Purely as an aside to your response, word wrap can be toggled on or off as
one of the two Fornat options in NotePad.

---
Regards,
Norman



"Dave O" wrote in message
oups.com...
An idea: click on the formula bar, highlight the entire formula, and
press CTRL-C to copy the formula into the clipboard. Then open MS Word
and press CTRL-V to paste. This will allow you to print the entire
formula.

As an alternative, if the formulas are _very_ similar and you want to
compare them character by character, copy the formulas to the clipboard
but this time paste them into Notepad. Notepad is a very handy, very
rudimentary text editor that does not perform a word wrap, so the
formula will be written out in its entirety with no line breaks.

Cool! Learn something new every day.