Cheat Sheet

Excel 2007 For Dummies Cheat Sheet

From Excel 2007 For Dummies

By Greg Harvey

In Microsoft Office Excel 2007, using the keystroke shortcuts (Alt + hot keys) instead of the ribbon will get you quickly through common view, file, and editing commands.

Shortcuts for Common File Commands in Excel 2007

Instead of using the ribbon for your basic file functions in Excel 2007, check out this chart for keystroke shortcuts ( Alt + hot key) to get your spreadsheet basic commands quickly accomplished.

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

Common Editing Command Shortcuts in Excel 2007

As an alternative to using the ribbon in Excel 2007, these shortcut keystrokes (Alt + hot key) get you moving quickly through basic spreadsheet editing functions.

Hot Keys Excel Ribbon Command Function
Alt+HVP Home | Paste | Paste Pastes the currently cut or copied cell selection or graphic
objects in the worksheet
Alt+HX Home | Cut Cuts the cell selection or selected graphic objects out of the
workbook and places them on the Windows Clipboard
Alt+HC Home | Copy Copies the cell selection or selected graphic objects to the
Windows Clipboard
Alt+FP Home | Format Painter Activates the Format Painter
Alt+FO Home | Clipboard Dialog Box Launcher Displays and hides the Clipboard task pane
Alt+HII Home | Insert | Insert Cells Opens Insert dialog box so you can indicate the direction in
which to shift existing cells to make room for the ones being
inserted
Alt+HIR Home | Insert | Insert Sheet Rows Inserts blank rows equal to the number of rows in the cell
selection
Alt+HIC Home | Insert | Insert Sheet Columns Inserts blank columns equal to the number of columns in the
cell selection
Alt+HIS Home | Insert | Insert Sheet Inserts a new worksheet in the workbook
Alt+HDD Home | Delete | Delete Cells Opens Delete dialog box so you can indicate the direction in
which to shift existing cells to replace the ones being
deleted
Alt+HDR Home | Delete | Sheet Rows Deletes rows equal to the number of rows in the cell
selection
Alt+HDC Home | Delete | Sheet Columns Deletes columns equal to the number of columns in the cell
selection
Alt+HDS Home | Delete | Sheet Deletes the current worksheet after warning you of data loss if
the sheet contains cell entries
Alt+HEA Home | Clear | Clear All Clears the contents, formatting, and comments from the cell
selection
Alt+HEF Home | Clear | Clear Formats Clears the formatting of the cell selection without removing
the contents and comments
Alt+HEC Home | Clear | Clear Contents Clears the contents of the cell selection without removing the
formatting and comments
Alt+HEM Home | Clear | Clear Comments Clears all comments in the cell selection without removing the
formatting and contents

Shortcuts for Common View Commands in Excel 2007

If you want to change the way you’re looking at an Excel 2007 spreadsheet, or the way the page is laid out, use these view command shortcuts (Alt + hot key).

Hot Keys Excel Ribbon Command Function
Alt+WN View | Normal View Returns the worksheet to normal view from Page Layout or Page
Break Preview
Alt+WP View | Page Layout View Puts the worksheet into Page Layout View showing the page
breaks, margins, and rulers
Alt+WI View | Page Break Preview Puts the worksheet into Page Break Preview showing pages breaks
that you can adjust
Alt+WE View | Full Screen Puts the worksheet in full-screen mode which hides the
Microsoft Office Button, Quick Access toolbar, and Ribbon – press
the Esc key to restore previous viewing mode
Alt+WVG View | Gridlines Hides and redisplays the row and column gridlines that form the
cells in the Worksheet area