print formula
 

i need to know how to get formula printed on the spreadsheet.

please advise

margaret


--
Bentleypiano

Tools Options ViewTab check "Formulas" box under "Window options"
OK.......

un-check the box to return to normal......


Vaya con Dios,
Chuck, CABGx3


"Bentleypiano" wrote in
message m...

i need to know how to get formula printed on the spreadsheet.

please advise

margaret


--
Bentleypiano

Hi bentleypiano,
If you mean printing the formula used in another cell, see

Show FORMULA or FORMAT of another cell
I prefer to show the formula in use for documentation purposes,
within the actual spreadsheet they are active in, which I think is the best choice.
http://www.mvps.org/dmcritchie/excel...htm#getformula

If not familiar with installing a User Defined Function see
http://www.mvps.org/dmcritchie/excel/getstarted.htm

use is similar to Excels own functions
=GetFormula(B4)
or if installed in a different workbook.
=personal.xls!GetFormula(B4)

---
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

"CLR" wrote...
Tools Options ViewTab check "Formulas" box under "Window options"
OK.......

un-check the box to return to normal......


"Bentleypiano" wrote ...

i need to know how to get formula printed on the spreadsheet.

please advise

margaret


--
Bentleypiano