Excel 2007 For Dummies
Book image
Explore Book Buy On Amazon

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

About This Article

This article is from the book:

About the book author:

Greg Harvey has authored tons of computer books, the most recent being Excel Workbook For Dummies and Roxio Easy Media Creator 8 For Dummies, and the most popular being Excel 2003 For Dummies and Excel 2003 All-In-One Desk Reference For Dummies. He started out training business users on how to use IBM personal computers and their attendant computer software in the rough and tumble days of DOS, WordStar, and Lotus 1-2-3 in the mid-80s of the last century. After working for a number of independent training firms, Greg went on to teach semester-long courses in spreadsheet and database management software at Golden Gate University in San Francisco.
His love of teaching has translated into an equal love of writing. For Dummies books are, of course, his all-time favorites to write because they enable him to write to his favorite audience: the beginner. They also enable him to use humor (a key element to success in the training room) and, most delightful of all, to express an opinion or two about the subject matter at hand.
Greg received his doctorate degree in Humanities in Philosophy and Religion with a concentration in Asian Studies and Comparative Religion last May. Everyone is glad that Greg was finally able to get out of school before he retired.

This article can be found in the category: