To just see it, look at the formula bar with the cell selected.
If you will be printing it see
http://www.mvps.org/dmcritchie/excel...htm#getformula
installation instructions in
http://www.mvps.org/dmcritchie/excel/getstarted.htm
usage on the worksheet, depending on where you installed, any of
=GetFormula(G3)
=personal.xls!GetFormula(G3)
If it is not obvious where the formula actually is you might instead use
=personal.xls!GetFormulaD(G3)
Look over the rest of the web page, there are formulas to obtain
the formatting in another cell, and a heck of a lot more.
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
"superchica" wrote...
How do I display only one formula on an Excell worksheet without showing all
of the formulas on my worksheet?