Common Editing Command Shortcuts in Excel 2007

Part of the Excel 2007 For Dummies Cheat Sheet

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
  • Add a Comment
  • Print
  • Share
blog comments powered by Disqus
Advertisement

Inside Dummies.com