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
|