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 |
dummies
Source:http://www.dummies.com/how-to/content/common-editing-command-shortcuts-in-excel-2007.html
No comments:
Post a Comment