formulas

[julieana]

I need to print out my spreadsheet showing the formulas in
the cells. How do I get it to show formulas?

 

[Katherine Coombs]

Hi Julieana,

Go to Tools-->Options and on the View tab check the option at the bottom
left that says "Formulas". Alternatively, press Control ~ and this will
show formulas instead of results.

BTW - you posted this as a reply to another post, which makes it difficult
for others to see that it's a question that needs addressing.

HTH,
Katherine

 

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

 

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