| Shortcut | To |
| Ctrl+Home | Jump to top left of workbook |
| Ctrl+End | Jump to the last cell in the last column of data |
| Ctrl+arrow key (←,→, ↑, ↓) | Jump to the end of the row/column. E.g., Ctrl+↓ goes to the last cell of data in a col). |
| Ctrl+asterisk (*) | Highlight an entire range in 1 keystoke |
| Ctrl+hyphen (-) | Open Delete dialog box. Use this to delete a cell, row, or column. |
| Ctrl+plus (+) | Open Insert dialog box. Use this to insert a cell, row, or column. |
| Ctrl+F | Find |
| Ctrl+H | Replace |
| Alt+WF | Freeze Panes (Window→Freeze) |
Sunday, November 25, 2007
Navigating within a Worksheet
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment