Editing information within a cell in Excel 2003 can get confusing without some guidance. Excel 2003 has plenty of keyboard shortcuts to make editing cells a breeze:
| Press | To |
|---|---|
| F2 | Edit current cell entry and position insertion point at the end of cell contents |
| Shift+F2 | Edit comment attached to current cell and position insertion point in comment box |
| Backspace | Delete character to left of insertion point when editing cell entry |
| Delete | Delete character to right of insertion point when editing cell entry; otherwise, clear cell entries in current range |
| Esc | Cancel editing in current cell entry |
| Enter | Complete editing in current cell entry |
| Ctrl+CC | Open Clipboard Task pane |
| Ctrl+C | Copy cell selection to Clipboard |
| Ctrl+X | Cut cell selection to Clipboard |
| Ctrl+V | Paste last copied or cut cells from Clipboard |
| Ctrl+hyphen (-) | Open Delete dialog box to delete cell selection and shift remaining cells left or up |
| Ctrl+Shift+plus (+) | Open Insert dialog box to insert new cells and shift existing cells right or down |
| Ctrl+Z | Undo last action |
| Ctrl+Y | Redo last action |
dummies
Source:http://www.dummies.com/how-to/content/keyboard-shortcuts-for-editing-cells-in-excel-2003.html
No comments:
Post a Comment