View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
JLatham JLatham is offline
external usenet poster
 
Posts: 3,365
Default 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