How to Access Common Formula Commands in Excel 2007 - dummies

How to Access Common Formula Commands in Excel 2007

By Greg Harvey

Part of Excel 2007 All-in-One For Dummies Cheat Sheet

Possibly the most useful — and used — function in Excel 2007 is the one that helps you create formulas so that you add, count, average, and generally do math functions with the data in your Excel worksheets. The information in the following table shows you which hot keys to press or Ribbon tab to choose to access the formula function you want:

Hot Keys Excel Ribbon Command Function
Alt+M,F Formulas | Function Wizard Opens the Insert Function dialog box
Alt+M,U,S Formulas | AutoSum | Sum Selects the occupied range above the cell cursor and inserts
SUM formula to total the range
Alt+M,U,A Formulas | AutoSum | Average Selects the occupied range above the cell cursor and inserts
AVERAGE formula to calculate the average of total in the range
Alt+M,U,C Formulas | AutoSum | Count Numbers Selects the occupied range above the cell cursor and inserts
COUNT formula to count the number of values in the range
Alt+M,I Formulas | Financial Opens a drop-down menu listing all Financial functions —
click name to insert function into current cell
Alt+M,E Formulas | Date & Time Opens a drop-down menu listing all Date and Time functions
— click name to insert function into current cell
Alt+M,N Formulas | Name Manager Opens Name Manager dialog box showing all range names in
workbook and letting you add, edit, and delete names
Alt+M,M,D Formulas | Define Name Opens New Name dialog box where you can assign a name to the
cell selection or define a new constant
Alt+M,S,1 Formulas | Use in Formula Displays drop-down menu with range names in workbook that you
can insert into current formula by clicking
Alt+M,C,1 Formulas | Create from Selection Opens Create Names from Selection dialog box where you indicate
which rows and columns to use in naming cell selection
Alt+M,H
Ctrl+’
Formulas | Show Formulas Displays and then hides all formulas in cells of the
worksheet
Alt+M,X,A Formulas | Options | Automatic Turns automatic recalculation back on
Alt+M,X,E Formulas | Options | Automatic Except for Data Tables Turns automatic recalculation back on for all parts of the
worksheet except for ranges with Data Tables
Alt+M,X,M Formulas | Options | Manual Turns on manual recalculation
Alt+M,B
F9
Formulas | Calculate Now Recalculates formulas throughout the entire workbook when
manual recalculation is turned on
Alt+M,J
Shift+F9
Formulas | Calculate Sheet Recalculates formulas in the current worksheet when manual
recalculation is turned on