ShortcutdrillExcel shortcuts / Excel navigation shortcuts
Excel navigation shortcuts
Navigation is where the mouse costs the most. A 50,000-row sheet takes minutes to scroll and two key presses to jump. Every shortcut below moves the active cell; add Shift to any of them and it selects on the way, which is covered on the selection page.
Learn Ctrl+Arrow first. It is the one shortcut that changes how you move through data, and most of the others are variations on it.
Jump to the edge of the data Ctrl+Arrow
Ctrl with an arrow key moves the active cell to the last filled cell in that direction. If the next cell is blank it jumps to the next filled cell instead. On a sheet with thousands of rows it replaces scrolling entirely. Practice: Jump to the bottom.
Jump to the last column of a row Ctrl+Right arrow
Ctrl+Right moves to the last filled cell of the current row. Ctrl+Left brings you back to the first. It is the fastest way to check how wide a table is or to reach the last column of a schedule. Practice: Jump to the last column.
Return to cell A1 Ctrl+Home
Ctrl+Home moves to A1 from anywhere on the sheet, or to the top-left unfrozen cell when panes are frozen. It is the reset button for a sheet you have wandered through. Practice: Back to the top.
Jump back up to the header Ctrl+Up arrow
Ctrl+Up moves to the first filled cell above, usually the header of the column. After a Ctrl+Down to check the bottom of a column, Ctrl+Up returns you in one press. Practice: Back up to the header.
Go to the start of the row Home
Home moves to column A of the current row. On a Mac laptop the Home key is Fn+Left. It pairs with Down to walk down the first column of a table. Practice: Start of the row.
Go to the last used cell Ctrl+End
Ctrl+End moves to the bottom-right corner of everything the sheet has ever used. If it lands far below your data, the sheet carries formatting or leftovers that bloat the file. Practice: Find the end of the data.
Find where a column stops Ctrl+Down arrow
Ctrl+Down stops at the last filled cell before a blank. Used deliberately it is the quickest way to find a missing value in a column: if it stops early, there is a hole. Practice: Where the data stops.
Cross a gap between two blocks Ctrl+Down arrow, twice
When data sits in two blocks with blank rows between them, the first Ctrl+Down reaches the end of the first block and the second lands on the start of the next. It works for any number of blank rows. Practice: Jump across the gap.
Go to a cell by address Ctrl+G, type the address, Enter
Ctrl+G (or F5) opens the Go To box. Type an address such as H250 or a range such as B2:F40 and press Enter. The box also lists named ranges and remembers where you came from. Practice: Go to a cell by address.
Jump to a named range F5, pick the name, Enter
The Go To box lists every defined name. Type the name or pick it from the list and the whole range is selected. Names survive inserted rows, so the jump keeps working as the model grows. Practice: Go to a named range.
Jump to the cells a formula uses Ctrl+[
With a formula cell active, Ctrl+[ selects every cell the formula reads from and makes the first one active. It is the keyboard version of Trace Precedents, without the arrows. Practice: Trace the precedent.
Return to where you came from F5, Enter
After a Go To or a precedent trace, the Go To box has your previous location pre-filled. F5 then Enter bounces you straight back. It makes auditing a chain of formulas a rhythm: Ctrl+[, look, F5 Enter. Practice: And jump back.
Jump to the cells that use this one Ctrl+]
Ctrl+] selects every formula that references the active cell and lands on the first. Use it before changing an input to see what moves. Practice: Trace the dependent.
Move to the next sheet Ctrl+Page Down
Ctrl+Page Down moves one sheet to the right; Ctrl+Page Up one to the left. A twelve-sheet model is navigated entirely with these two keys. Practice: Next sheet.
Find the last cell on a wide sheet Ctrl+End
On a sheet that extends to the right as well as down, Ctrl+End goes to the corner where both end. Follow it with Ctrl+Home to size the sheet in two presses. Practice: Last cell on the sheet.
Back to the top left from anywhere Ctrl+Home
Wherever you are, Ctrl+Home puts the active cell at A1 (or the first unfrozen cell). Press it before you hand a file over, so it opens at the top. Practice: Back to the top left.
Select every error cell Ctrl+G, Alt+S, K, Enter
Go To Special can select every cell of a kind: blanks, constants, formulas, or formulas that return errors. Ctrl+G, Alt+S opens it; K picks formulas with errors; Enter selects them all and lands on the first. Practice: Next error.