Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Where can I find list/table of functions/formulas
I'd like to find a list or table of all the various functions/commands and
the keystroke commands. By that I mean when you hit CNTRL + ; it give today's date. Other things like that. Is there a list someplace? -- Rich D Armstrong Custom Homes Redmond |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Where can I find list/table of functions/formulas
Check this out http://www.cpearson.com/excel/ShortCuts.htm
-- --- HTH Bob (change the xxxx to gmail if mailing direct) "Rich D" wrote in message ... I'd like to find a list or table of all the various functions/commands and the keystroke commands. By that I mean when you hit CNTRL + ; it give today's date. Other things like that. Is there a list someplace? -- Rich D Armstrong Custom Homes Redmond |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Where can I find list/table of functions/formulas
Hi Rich,
In Excel Help, search for "keyboard shortcuts" -- Kind regards, Niek Otten Microsoft MVP - Excel "Rich D" wrote in message ... | I'd like to find a list or table of all the various functions/commands and | the keystroke commands. By that I mean when you hit CNTRL + ; it give | today's date. Other things like that. Is there a list someplace? | -- | Rich D | Armstrong Custom Homes | Redmond |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Where can I find list/table of functions/formulas
They are called keyboard shortcuts, you will find them in HELP,
but they are hard to look at there because you can only see a few at a time, see ... http://www.mvps.org/dmcritchie/excel/shortx2k.htm --- HTH, David McRitchie, Microsoft MVP - Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Rich D" wrote in message ... I'd like to find a list or table of all the various functions/commands and the keystroke commands. By that I mean when you hit CNTRL + ; it give today's date. Other things like that. Is there a list someplace? -- Rich D Armstrong Custom Homes Redmond |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Where can I find list/table of functions/formulas
Search Excel's Help for 'keyboard shortcuts' - they're all in there - initial
page will show you their general grouping, links will show you the detailed keystrokes. "Rich D" wrote: I'd like to find a list or table of all the various functions/commands and the keystroke commands. By that I mean when you hit CNTRL + ; it give today's date. Other things like that. Is there a list someplace? -- Rich D Armstrong Custom Homes Redmond |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Where can I find list/table of functions/formulas
I see now that your question was actually ambiguous and you may have
been trying to ask MORE than one question. Where to see a list of functions in Excel if you see Fx on your toolbar then click on that then choose "All" for the category, if you click on a function you will see a little syntax below. using SHIFT+F1 or dragging the [?] to an item does not help you much with this particular dialog box. In HELP if you type in Function you will get a list of cateogries and can work from there. If you would like a working workbook with many of the builtin Functions shown as examples see Excel Function Dictionary « by Peter Noneley, which is a reference to definitely download and maintain on your computer, the workbook has 157+ sheets each with an explanation and example of an Excel function. http://www.rondebruin.nl/id.htm If you want a listing showing the names and some additional information for each of your own Functions and Macros you can list their names with see Subroutine and Function Table for Open Workbooks http://www.mvps.org/dmcritchie/excel...nctionsAndSubs if you have never installed a macro before, see http://www.mvps.org/dmcritchie/excel/getstarted.htm and my previous answer was, of course They are called keyboard shortcuts, you will find them in HELP, but they are hard to look at there because you can only see a few at a time, see ... http://www.mvps.org/dmcritchie/excel/shortx2k.htm --- HTH, David McRitchie, Microsoft MVP - Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Rich D" wrote ... I'd like to find a list or table of all the various functions/commands and the keystroke commands. By that I mean when you hit CNTRL + ; it give today's date. Other things like that. Is there a list someplace? -- Rich D Armstrong Custom Homes Redmond |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Where can I find list/table of functions/formulas
Now THAT'S an answer! Great.
"David McRitchie" wrote: I see now that your question was actually ambiguous and you may have been trying to ask MORE than one question. Where to see a list of functions in Excel if you see Fx on your toolbar then click on that then choose "All" for the category, if you click on a function you will see a little syntax below. using SHIFT+F1 or dragging the [?] to an item does not help you much with this particular dialog box. In HELP if you type in Function you will get a list of cateogries and can work from there. If you would like a working workbook with many of the builtin Functions shown as examples see Excel Function Dictionary « by Peter Noneley, which is a reference to definitely download and maintain on your computer, the workbook has 157+ sheets each with an explanation and example of an Excel function. http://www.rondebruin.nl/id.htm If you want a listing showing the names and some additional information for each of your own Functions and Macros you can list their names with see Subroutine and Function Table for Open Workbooks http://www.mvps.org/dmcritchie/excel...nctionsAndSubs if you have never installed a macro before, see http://www.mvps.org/dmcritchie/excel/getstarted.htm and my previous answer was, of course They are called keyboard shortcuts, you will find them in HELP, but they are hard to look at there because you can only see a few at a time, see ... http://www.mvps.org/dmcritchie/excel/shortx2k.htm --- HTH, David McRitchie, Microsoft MVP - Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Rich D" wrote ... I'd like to find a list or table of all the various functions/commands and the keystroke commands. By that I mean when you hit CNTRL + ; it give today's date. Other things like that. Is there a list someplace? -- Rich D Armstrong Custom Homes Redmond |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Where can I find list/table of functions/formulas
Yep, Dave always gives a great answer.
And the Excel Function Dictionary he mentioned is now at www.xlfdic.com Thanks Dave. Peter Noneley Cardiff (Dark, wet, cold) Wales UK www.xlfdic.com JLatham (removethis) wrote: Now THAT'S an answer! Great. "David McRitchie" wrote: I see now that your question was actually ambiguous and you may have been trying to ask MORE than one question. Where to see a list of functions in Excel if you see Fx on your toolbar then click on that then choose "All" for the category, if you click on a function you will see a little syntax below. using SHIFT+F1 or dragging the [?] to an item does not help you much with this particular dialog box. In HELP if you type in Function you will get a list of cateogries and can work from there. If you would like a working workbook with many of the builtin Functions shown as examples see Excel Function Dictionary « by Peter Noneley, which is a reference to definitely download and maintain on your computer, the workbook has 157+ sheets each with an explanation and example of an Excel function. http://www.rondebruin.nl/id.htm If you want a listing showing the names and some additional information for each of your own Functions and Macros you can list their names with see Subroutine and Function Table for Open Workbooks http://www.mvps.org/dmcritchie/excel...nctionsAndSubs if you have never installed a macro before, see http://www.mvps.org/dmcritchie/excel/getstarted.htm and my previous answer was, of course They are called keyboard shortcuts, you will find them in HELP, but they are hard to look at there because you can only see a few at a time, see ... http://www.mvps.org/dmcritchie/excel/shortx2k.htm --- HTH, David McRitchie, Microsoft MVP - Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Rich D" wrote ... I'd like to find a list or table of all the various functions/commands and the keystroke commands. By that I mean when you hit CNTRL + ; it give today's date. Other things like that. Is there a list someplace? -- Rich D Armstrong Custom Homes Redmond |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Where can I find list/table of functions/formulas
Hi Peter,
Glad to see you've got your own site once more. I've fixed my links to your new site. -- David "Peter Noneley" wrote ... Yep, Dave always gives a great answer. And the Excel Function Dictionary he mentioned is now at www.xlfdic.com Thanks Dave. Peter Noneley Cardiff (Dark, wet, cold) Wales UK www.xlfdic.com Excel Function Dictionary « by Peter Noneley, which is a reference to definitely download and maintain on your computer, the workbook has 157+ sheets each with an explanation and example of an Excel function. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find Function | Excel Discussion (Misc queries) | |||
Find and Replace | Excel Worksheet Functions | |||
Code needed to find records from bottom up | Excel Discussion (Misc queries) | |||
find a cells from a range of cell | Excel Worksheet Functions | |||
Excel has a "Find Next" command but no "Find Previous" command. | Excel Discussion (Misc queries) |