Online Test Banks
Score higher
See Online Test Banks
eLearning
Learning anything is easy
Browse Online Courses
Mobile Apps
Learning on the go
Explore Mobile Apps
Dummies Store
Shop for books and more
Start Shopping

How to Access Common Excel 2007 Formula Commands

Part of the Excel 2007 Workbook For Dummies Cheat Sheet

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 the range.
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 selection.
Formulas | Show Formulas Alt+MH or Ctrl+` Displays and then hides all formulas in cells of the worksheet.
  • Add a Comment
  • Print
  • Share
blog comments powered by Disqus

SERIES
Excel 2007 Workbook For Dummies Cheat Sheet

Advertisement

Inside Dummies.com

Dummies.com Sweepstakes

Win $500. Easy.