Printing formulas on a worksheet

B

bakerdmw

I have a worksheet with a long formula and have tried to print the worksheet
with the formula using the formulating audit. Only part of the formula
prints. How can I get the entire formula to print? I have tried formatting
the cell with no luck. Help!
 
K

Kevin Vaughn

I've seen this method suggested for other times when cell contents were too
long for printing, and I've read and just tested that Alt Enter can be used
in a cell with a formula, so try splitting the formula up with Alt-Enter
every (I believe) 80 to 120 characters. I did it with a rather short
formula, and not sure if pasting will show it correctly (or I might need to
add enters so it shows:)

=IF(
A8="no",
0,
1)

No it shows.
 
B

bakerdmw

Thank you Kevin I will try it.

Kevin Vaughn said:
I've seen this method suggested for other times when cell contents were too
long for printing, and I've read and just tested that Alt Enter can be used
in a cell with a formula, so try splitting the formula up with Alt-Enter
every (I believe) 80 to 120 characters. I did it with a rather short
formula, and not sure if pasting will show it correctly (or I might need to
add enters so it shows:)

=IF(
A8="no",
0,
1)

No it shows.
Click to expand...
 
Top