Cheat Sheet

Excel 2007 For Dummies

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

Inside Dummies.com