Printing formulas on a worksheet

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!