J
julieana
I need to print out my spreadsheet showing the formulas in
the cells. How do I get it to show formulas?
the cells. How do I get it to show formulas?
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.
J
jennyfer
You would need to to to Tools, Options, View. Then in
the "Window Options" area, make sure FORMULAS is checked.
It's an easy step.
the "Window Options" area, make sure FORMULAS is checked.
It's an easy step.
D
David McRitchie
Hi Julieana,
If you want to document the formulas or figure out if they are correct
or not, I find it much nicer to view the spreadsheet intact but to show
some representative formulas or perhaps a column of formulas so you
see everything. Take a look at code and instructions to install
GetFormula and GetFormulaD in
Show FORMULA of another cell in Excel
http://www.mvps.org/dmcritchie/excel/formula.htm
usage: =GetFormula(A3) -- these are User Defined Functions
=GetFormulaD(A3)
=personal.xls!GetFormula(A3)
Function GetFormula(Cell)
GetFormula = Cell.Formula
End Function
The use of a single word for the subject causes those viewing with many
browsers and specifically Outlook Express to see your posting as if
in response to another thread -- I can see it isn't because there is no
reference in the headers. But it would be a good idea to describe
in the subject what you are looking for to help people find answers
when they search the archives. Searching the archives is always
a good idea more information in
http://www.mvps.org/dmcritchie/excel/xlnews.htm
Google is notorious for putting postings with the same subject together
in what looks like a single thread when you search the archives.
Lots of things are messing up the newsgroups lately, well most
of it has been for some time -- just getting worse. :
CDO (Microsoft communities) with anonomous posting, and
failure to include reply prefix. Mr Excel resubmitting questions
to newsgroups and not threading their own users responses back
to the correct part of a thread in the actual newsgroup thread.
If you want to document the formulas or figure out if they are correct
or not, I find it much nicer to view the spreadsheet intact but to show
some representative formulas or perhaps a column of formulas so you
see everything. Take a look at code and instructions to install
GetFormula and GetFormulaD in
Show FORMULA of another cell in Excel
http://www.mvps.org/dmcritchie/excel/formula.htm
usage: =GetFormula(A3) -- these are User Defined Functions
=GetFormulaD(A3)
=personal.xls!GetFormula(A3)
Function GetFormula(Cell)
GetFormula = Cell.Formula
End Function
The use of a single word for the subject causes those viewing with many
browsers and specifically Outlook Express to see your posting as if
in response to another thread -- I can see it isn't because there is no
reference in the headers. But it would be a good idea to describe
in the subject what you are looking for to help people find answers
when they search the archives. Searching the archives is always
a good idea more information in
http://www.mvps.org/dmcritchie/excel/xlnews.htm
Google is notorious for putting postings with the same subject together
in what looks like a single thread when you search the archives.
Lots of things are messing up the newsgroups lately, well most
of it has been for some time -- just getting worse. :
CDO (Microsoft communities) with anonomous posting, and
failure to include reply prefix. Mr Excel resubmitting questions
to newsgroups and not threading their own users responses back
to the correct part of a thread in the actual newsgroup thread.