print formula

[Bentleypiano]

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

please advise

margaret


--
Bentleypiano

[CLR]

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

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


Vaya con Dios,
Chuck, CABGx3


"Bentleypiano" <[email protected]> wrote in
message news:[email protected]...
>
> i need to know how to get formula printed on the spreadsheet.
>
> please advise
>
> margaret
>
>
> --
> Bentleypiano

[David McRitchie]

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" <[email protected]> wrote...
> Tools > Options > ViewTab > check "Formulas" box under "Window options" >
> OK.......
>
> un-check the box to return to normal......
>
>
> "Bentleypiano" <[email protected]> wrote ...
> >
> > i need to know how to get formula printed on the spreadsheet.
> >
> > please advise
> >
> > margaret
> >
> >
> > --
> > Bentleypiano
>
>