You're welcome. Hope it works for you.
--
Kevin Vaughn


"bakerdmw" wrote:

Thank you Kevin I will try it.

"Kevin Vaughn" wrote:

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.
--
Kevin Vaughn


"bakerdmw" wrote:

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!