Cheat Sheet

Excel 2007 Workbook For Dummies

Microsoft Office Excel 2007 is an extremely powerful and useful application. But all the tools, buttons, drop-down boxes, and pop-up windows that give you access to Excel's power from the Ribbon can intimidate Excel beginners. But don't worry — this cheat sheet shows you how to use Excel's most common tools and commands with just a few key presses.

How to Access Common Excel 2007 File Commands

You can run Excel 2007's basic file commands in two different ways: by pressing a combination of shortcut keys or by clicking in the Excel Ribbon. The following chart shows some of the most common file commands in Excel 2007 and the two ways you can access them:

Excel Ribbon Command Access Keys Function
Microsoft Office Button | New Alt+FN Displays the New Workbook dialog box, where you can open a blank workbook or one from a template.
Microsoft Office Button | Open Alt+FO or Ctrl+O Displays the Open dialog box, where you can select an Excel workbook to open for editing or printing.
Microsoft Office Button | Save Alt+FS or Ctrl+S Saves changes to a workbook. When you first select this command for a new workbook, Excel displays the Save As dialog box.
Microsoft Office Button | Save As Alt+FA Display the Save As dialog box, where you can modify the filename, location where the file is saved, and format that the file is saved in.
Microsoft Office Button | Print Alt+FP or Ctrl+P Displays the Print dialog box to send the current worksheet, workbook, or cell selection to the printer.
Microsoft Office Button | Send Alt+FD Sends the current workbook as an e-mail attachment or faxes it using Internet Fax.
Microsoft Office Button | Close Alt+FC Closes the current workbook without exiting Excel.
Microsoft Office Button | Excel Options Alt+FI Displays the Excel Options dialog box, where you can change default program settings and modify the buttons on the Quick Access toolbar.
Microsoft Office Button | Exit Excel Alt+FX Quits the Excel program and closes all open workbooks after prompting you to save them.

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 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.
blog comments powered by Disqus
Advertisement

Inside Dummies.com