Excel 2010 Hot Keys for Editing Commands

You activate all of the Excel 2010 hot keys by pressing down the Alt key before you type the various sequences of mnemonic letters. The mnemonic letter for all of the editing commands is H (for Home) because all of these commands are conveniently located on the Home tab of the Ribbon.

However, even if you can remember to associate editing with the Home tab and keep in mind that Alt+H is always the starting point, you’re still not home free because 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), which are a lot quicker than their Alt+H equivalents, provided that you already know and regularly use them.

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+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 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

dummies

Source:http://www.dummies.com/how-to/content/excel-2010-hot-keys-for-editing-commands.html