In large tables the mouse is slow. Here is how to get where you need quickly.
Keys
| Ctrl+←↑→↓ | to the edge of the data region; with Shift — select to the edge |
| Ctrl+Home / Ctrl+End | to A1 / to the last used cell of the sheet |
| PgUp / PgDn, Alt+PgUp / PgDn | one screen up/down, left/right |
| Ctrl+PgUp / PgDn | previous / next sheet |
| Ctrl+Backspace | scroll back to the active cell if you lost it |
| F5 or Ctrl+G | the Go To dialog: an address, range or name; the Special… button opens Go To Special |
| Ctrl+F / Ctrl+H | find / replace |
The Name Box
Type an address (T60), a range (B2:B51) or a name into the Name Box and press Enter — Excel goes there and selects it. Select a range and type a new word into the Name Box, and the range gets that name.
Go To Special
Home → Find & Select → Go To Special (or F5 → Special…). Selects all formulas, constants, blanks, the last cell or visible cells only, at once. Example: select the blank cells and fill them all with one Ctrl+Enter.
The View tab
- Navigation — a pane on the right listing the sheets and objects of the workbook (Excel for Microsoft 365).
- Freeze Panes — the table header stays in place while you scroll: Freeze Top Row, Freeze First Column, or everything above and left of the active cell.
- Zoom — also the slider in the status bar and Ctrl+mouse wheel.
Right-click the arrows left of the sheet tabs to get a list of all sheets — handy when there are dozens.
Excel for Mac. Use ⌘+arrows instead of Ctrl+arrows. Go To is Ctrl+G or fn+F5; Go To Special is Edit → Find → Go To → Special. There is no Navigation pane in Excel for Mac. Freeze Panes is on the View tab, as in Windows.