Excel formula printing

C

canuck

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

Dave O

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

Norman Jones

Hi Dave,
Notepad is a very handy, very
rudimentary text editor that does not perform a word wrap
Click to expand...

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