How to Access Common Excel 2007 Formula Commands
The following chart helps get you around easier in Excel 2007. It shows you the quickest way to access Excel’s basic formula commands either with the Excel Ribbon or by pressing shortcut keys:
|Excel Ribbon Command||Access Keys||Function|
|Formulas | Insert Function||Alt+MF||Opens the Insert Function dialog box (same as clicking the
Insert Function button on the Formula bar).
|Formulas | AutoSum | Sum||Alt+MUS||Selects the occupied range above and to the left of the cell
cursor and inserts the SUM formula to total the range.
|Formulas | AutoSum | Average||Alt+MUA||Selects the occupied range above and to the left of the cell
cursor and inserts the AVERAGE formula to calculate the average in
|Formulas | AutoSum | Count Numbers||Alt+MUC||Selects the occupied range above the cell cursor and inserts
the COUNT formula to count the number of values in the range.
|Formulas | Financial||Alt+MI||Opens a drop-down menu listing all Financial functions —
click name to insert function into current cell.
|Formulas | Date & Time||Alt+ME||Opens a drop-down menu listing all Date and Time functions
— click name to insert function into current cell.
|Formulas | Name Manager||Alt+MN||Opens Name Manager dialog box showing all range names in
workbook where you can add, edit, and delete names.
|Formulas | Define Name||Alt+MMD||Opens New Name dialog box, where you can assign a name to the
cell selection or define a new constant.
|Formulas | Use in Formula||Alt+MS||Displays drop-down menu with range names in workbook that you
can insert into current formula by clicking.
|Formulas | Create from Selection||Alt+MC||Opens Create Names from Selection dialog box, where you
indicate which rows and columns to use in naming cell
|Formulas | Show Formulas||Alt+MH or Ctrl+`||Displays and then hides all formulas in cells of the