Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
Cool! Learn something new every day.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problems printing templates in Excel XP | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
How do I get the formula bar in excel 2003 | Excel Discussion (Misc queries) | |||
Excel 2003 - Formula result shows as 0:00 | Excel Worksheet Functions |