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!

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!

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!

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!