Formula

[Guest]

I have plenty of sheets who work togheter with formulas, but I wonder how I
can see all the formulas in one sheet. In the norwegian office the short key
for that is"ctrl+j" What is the short key in the USA/English office?

 

[Anne Troy]

See: http://www.officearticles.com/excel/microsoft_excel_shortcut_keys.htm

Your shortcut is Ctrl+ '

*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com

 

[David McRitchie]

Actually not a single quote but an accent grave which is to the
left of the number row, and it that is not the character to the left
is may be that you still should use the character to the left.
Ctrl+` (accent grave)

The shortcuts file of Anne's that she referred you to shows accent grave.

There are some methods of displaying formulas that I prefer
and that is to show a few (very few) representative formulas
using a User Defined Function. see GetFormula and GetFormulaD in
http://www.mvps.org/dmcritchie/excel/formula.htm

 

[Anne Troy]

My bad. Thanks, Dave!
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com

 

[Guest]

I understand, but I want to see all the formulas that is in the sheet. I have
done it before, but can`t remeber the shortkey.
Anne Troy skrev:

 

[David McRitchie]

Not all keyboards are the same, for most people it is Ctrl + `
which is hold Ctrl key and press accent grave OR
Ctrl + whatever key is to the left of the number row.

See this thread for a macro alternative that you can assign your
own shortcut key
http://groups.google.co.uk/groups?threadm=01bd1e07$d260b740$0e8582c3@ber

as an alternative to the Ctrl+` (toggle) or the
Tools --> Options --> View --> (check or uncheck) formula view

What language are you using (i.e. Dutch) and what version of Excel
and is there any key to the left of the number row.

That is all for the toggling into and out of formula view in Excel, there are
also macros to list on another sheet the location of a cell (.address), the value (.value),
the displayed value (.text), for format (.numberformat) and the value of the cells in column A and
of ROW 1 as a reference. Take a look at for starters
http://j-walk.com/ss/excel/tips/tip37.htm..

 

[Guest]

Thanks, Tools --> Options --> View --> (check or uncheck) formula view
was the answer I need

David McRitchie skrev: