Hot Keys for Common Excel 2013 Editing Commands

By Greg Harvey

Part of Excel 2013 All-in-One For Dummies Cheat Sheet

If you can remember that H stands for Home, you can remember that Alt+H starts Excel 2013’s hot key sequence for commands on the Ribbon’s Home tab. The remaining letters in the hot key sequences are not as easy to remember as you might like. Fortunately, the most common editing commands (Cut, Copy, and Paste) still respond to the old Ctrl+key sequences (Ctrl+X, Ctrl+C, and Ctrl+V, respectively). If you already know and use the old standbys, you’ll find them to be quicker than their Alt+H equivalents.

Hot Key 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+HFP Home→Format Painter Activates the Format Painter
Alt+HFO Home→Clipboard Dialog Box Launcher Displays and hides the Clipboard task pane
Alt+HII Home→Insert→Insert Cells Opens the 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 the 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