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..
---
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
Matz said:
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:
My bad. Thanks, Dave!
*******************
~Anne Troy
www.OfficeArticles.com
www.MyExpertsOnline.com
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
---
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
See:
http://www.officearticles.com/excel/microsoft_excel_shortcut_keys.htm
Your shortcut is Ctrl+ '
*******************
~Anne Troy
www.OfficeArticles.com
www.MyExpertsOnline.com
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?
