Hot Keys for Excel 2010 Editing Commands

To activate Excel 2010 hot keys, you press the Alt key before you type the mnemonic letters for a particular task. The mnemonic letter is H (Home) for the editing commands because these commands are located on the Home tab. The remaining letters in the hot key sequences are not so intuitive.


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), and you may find them quicker to use.


































































































Hot Key Excel Ribbon Command Function
Alt+HVPHome→Paste→PastePastes the currently cut or copied cell selection or graphic objects in the worksheet
Alt+HXHome→CutCuts the cell selection or selected graphic objects out of the workbook and places them on the Windows Clipboard
Alt+HCHome→CopyCopies the cell selection or selected graphic objects to the Windows Clipboard
Alt+HFPHome→Format PainterActivates the Format Painter
Alt+HFOHome→Clipboard Dialog Box LauncherDisplays and hides the Clipboard task pane
Alt+HIIHome→Insert→Insert CellsOpens Insert dialog box so you can indicate the direction in which to shift existing cells to make room for the ones being inserted
Alt+HIRHome→Insert→Insert Sheet RowsInserts blank rows equal to the number of rows in the cell selection
Alt+HICHome→Insert→Insert Sheet ColumnsInserts blank columns equal to the number of columns in the cell selection
Alt+HISHome→Insert→Insert SheetInserts a new worksheet in the workbook
Alt+HDDHome→Delete→Delete CellsOpens Delete dialog box so you can indicate the direction in which to shift existing cells to replace the ones being deleted
Alt+HDRHome→Delete→Delete Sheet RowsDeletes rows equal to the number of rows in the cell selection
Alt+HDCHome→Delete→Delete Sheet ColumnsDeletes columns equal to the number of columns in the cell selection
Alt+HDSHome→Delete→SheetDeletes the current worksheet after warning you of data loss if the sheet contains cell entries
Alt+HEAHome→Clear→Clear AllClears the contents, formatting, and comments from the cell selection
Alt+HEFHome→Clear→Clear FormatsClears the formatting of the cell selection without removing the contents and comments
Alt+HECHome→Clear→Clear ContentsClears the contents of the cell selection without removing the formatting and comments
Alt+HEMHome→Clear→Clear CommentsClears all comments in the cell selection without removing the formatting and contents
Alt+HELHome→Clear→Clear HyperlinksClears all hyperlinks in the cell selection without removing the formatting and contents







dummies

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

No comments:

Post a Comment