software

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=quot;noquot;,
0,
1)

No it shows.
--
Kevin Vaughnquot;bakerdmwquot; wrote:

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

Thank you Kevin I will try it.

quot;Kevin Vaughnquot; wrote:

gt; I've seen this method suggested for other times when cell contents were too
gt; long for printing, and I've read and just tested that Alt Enter can be used
gt; in a cell with a formula, so try splitting the formula up with Alt-Enter
gt; every (I believe) 80 to 120 characters. I did it with a rather short
gt; formula, and not sure if pasting will show it correctly (or I might need to
gt; add enters so it shows
gt;
gt; =IF(
gt; A8=quot;noquot;,
gt; 0,
gt; 1)
gt;
gt; No it shows.
gt; --
gt; Kevin Vaughn
gt;
gt;
gt; quot;bakerdmwquot; wrote:
gt;
gt; gt; I have a worksheet with a long formula and have tried to print the worksheet
gt; gt; with the formula using the formulating audit. Only part of the formula
gt; gt; prints. How can I get the entire formula to print? I have tried formatting
gt; gt; the cell with no luck. Help!

You're welcome. Hope it works for you.
--
Kevin Vaughnquot;bakerdmwquot; wrote:

gt; Thank you Kevin I will try it.
gt;
gt; quot;Kevin Vaughnquot; wrote:
gt;
gt; gt; I've seen this method suggested for other times when cell contents were too
gt; gt; long for printing, and I've read and just tested that Alt Enter can be used
gt; gt; in a cell with a formula, so try splitting the formula up with Alt-Enter
gt; gt; every (I believe) 80 to 120 characters. I did it with a rather short
gt; gt; formula, and not sure if pasting will show it correctly (or I might need to
gt; gt; add enters so it shows
gt; gt;
gt; gt; =IF(
gt; gt; A8=quot;noquot;,
gt; gt; 0,
gt; gt; 1)
gt; gt;
gt; gt; No it shows.
gt; gt; --
gt; gt; Kevin Vaughn
gt; gt;
gt; gt;
gt; gt; quot;bakerdmwquot; wrote:
gt; gt;
gt; gt; gt; I have a worksheet with a long formula and have tried to print the worksheet
gt; gt; gt; with the formula using the formulating audit. Only part of the formula
gt; gt; gt; prints. How can I get the entire formula to print? I have tried formatting
gt; gt; gt; the cell with no luck. Help!