P
PattiP
I want a hard copy of all the formulas on a spreadsheet. How do I print that?
Thanks!
Thanks!
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
S
Sloth
Tools->Options->View
Select "Formulas" checkbox to show all formulas. It temporarily changes the
column width.
Select "Formulas" checkbox to show all formulas. It temporarily changes the
column width.
R
Ron de Bruin
D
David McRitchie
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/formula.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/formula.htm#formulasheet
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/formula.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/formula.htm#formulasheet
P
PattiP
Thanks to you all for your help!
--
Patti
--
Patti
David McRitchie said: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/formula.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/formula.htm#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 said:I want a hard copy of all the formulas on a spreadsheet. How do I print that?