printing formulas

I want a hard copy of all the formulas on a spreadsheet. How do I print that?
Thanks!
--
Patti

Tools->Options->View
Select "Formulas" checkbox to show all formulas. It temporarily changes the
column width.

"PattiP" wrote:

> I want a hard copy of all the formulas on a spreadsheet. How do I print that?
> Thanks!
> --
> Patti

Hi PattiP

See
http://www.rondebruin.nl/print.htm#Formulas


--
Regards Ron de Bruin
http://www.rondebruin.nl


"PattiP" <PattiP@discussions.microsoft.com> wrote in message news:D3785B3F-C226-4D8E-BD94-E2F0D2C2A2F4@microsoft.com...
>I want a hard copy of all the formulas on a spreadsheet. How do I print that?
> Thanks!
> --
> Patti

Hi Patti, (basically same references as in Ron's reply)
Normally one only needs a few representative formulas, so rather than printing
out a sheet with address, formatted value, value, formula, formatting
you might find it more helpful to just add a few cells here and there or even
an entire column with a user defined function. See use of
GetFormula, GetFormulaD in
Show FORMULA or FORMAT of another cell
http://www.mvps.org/dmcritchie/excel/formula.htm
http://www.mvps.org/dmcritchie/excel...htm#cellformat and #GetFormulaExample

or for what you asked for see (has a few more column than J-Walks tip 37)
FormulaSheet - Print information for each non empty cell (#formulasheet)
http://www.mvps.org/dmcritchie/excel...m#formulasheet

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"PattiP" <PattiP@discussions.microsoft.com> wrote ...
> I want a hard copy of all the formulas on a spreadsheet. How do I print that?

Thanks to you all for your help!

--
Patti


"David McRitchie" wrote:

> Hi Patti, (basically same references as in Ron's reply)
> Normally one only needs a few representative formulas, so rather than printing
> out a sheet with address, formatted value, value, formula, formatting
> you might find it more helpful to just add a few cells here and there or even
> an entire column with a user defined function. See use of
> GetFormula, GetFormulaD in
> Show FORMULA or FORMAT of another cell
> http://www.mvps.org/dmcritchie/excel/formula.htm
> http://www.mvps.org/dmcritchie/excel...htm#cellformat and #GetFormulaExample
>
> or for what you asked for see (has a few more column than J-Walks tip 37)
> FormulaSheet - Print information for each non empty cell (#formulasheet)
> http://www.mvps.org/dmcritchie/excel...m#formulasheet
>
> ---
> HTH,
> David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
> My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
> Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
>
> "PattiP" <PattiP@discussions.microsoft.com> wrote ...
> > I want a hard copy of all the formulas on a spreadsheet. How do I print that?
>
>
>