| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Formula
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? |
|
#2
|
|||
|
|||
|
See: http://www.officearticles.com/excel/...rtcut_keys.htm
Your shortcut is Ctrl+ ' ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "matz" wrote in message ... 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? |
|
#3
|
|||
|
|||
|
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 "Anne Troy" wrote in message news:ad042$42b5a81a$466eb880$29253@allthenewsgroup s.com... See: http://www.officearticles.com/excel/...rtcut_keys.htm Your shortcut is Ctrl+ ' ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "matz" wrote in message ... 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? |
|
#4
|
|||
|
|||
|
My bad. Thanks, Dave!
******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "David McRitchie" wrote in message ... 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 "Anne Troy" wrote in message news:ad042$42b5a81a$466eb880$29253@allthenewsgroup s.com... See: http://www.officearticles.com/excel/...rtcut_keys.htm Your shortcut is Ctrl+ ' ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "matz" wrote in message ... 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? |
|
#5
|
|||
|
|||
|
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 "David McRitchie" wrote in message ... 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 "Anne Troy" wrote in message news:ad042$42b5a81a$466eb880$29253@allthenewsgroup s.com... See: http://www.officearticles.com/excel/...rtcut_keys.htm Your shortcut is Ctrl+ ' ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "matz" wrote in message ... 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? |
|
#6
|
|||
|
|||
|
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?th...8582c3%40be r 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" wrote in message ... 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 "David McRitchie" wrote in message ... 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 "Anne Troy" wrote in message news:ad042$42b5a81a$466eb880$29253@allthenewsgroup s.com... See: http://www.officearticles.com/excel/...rtcut_keys.htm Your shortcut is Ctrl+ ' ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "matz" wrote in message ... 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? |
|
#7
|
|||
|
|||
|
Thanks, Tools -- Options -- View -- (check or uncheck) formula view
was the answer I need:) David McRitchie skrev: 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?th...8582c3%40be r 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" wrote in message ... 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 "David McRitchie" wrote in message ... 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 "Anne Troy" wrote in message news:ad042$42b5a81a$466eb880$29253@allthenewsgroup s.com... See: http://www.officearticles.com/excel/...rtcut_keys.htm Your shortcut is Ctrl+ ' ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "matz" wrote in message ... 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
| Simplify formula | Excel Worksheet Functions | |||
| put formula results into a different cell if it is empty | Excel Worksheet Functions | |||
| how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Linear Mode
