Excel Navigation and Selection Shortcuts: Move Around Faster

Part of the free Module 1: Excel Shortcut Keys · Lesson 1 of 8 · Full Excel course

Updated on 5 September 2026 · Works in Excel 365, 2021, 2019 and 2016 unless noted.

Excel navigation shortcuts are the keys that move the active cell and extend a selection without the mouse: the Arrow keys, Ctrl + Arrow to jump to the edge of a data block, Ctrl + Shift + Arrow to select to that edge, Ctrl + Home and Ctrl + End for the corners of the sheet, and Ctrl + A for the whole region. Learn these first: every other shortcut in this course assumes you can land on the right cells quickly.

Moving around a worksheet

The Arrow keys move one cell. Tab moves right and Shift + Tab moves left, which is the fastest way to fill a row of inputs. Enter moves down and Shift + Enter moves up. If you have typed across a row with Tab and then press Enter, Excel returns to the column where you started, so a data-entry row can be typed without touching a mouse.

Page Down and Page Up scroll one screen vertically. Alt + Page Down and Alt + Page Up scroll one screen horizontally, which is useful on wide reports. Ctrl + Home goes to A1 (or to the first unfrozen cell when panes are frozen). Ctrl + End goes to the last cell Excel considers used, which is the bottom-right corner of the used range. Ctrl + Backspace scrolls the window back to the active cell after you have scrolled away from it.

The most important key in this group is Ctrl + Arrow. It jumps to the edge of the current data block in that direction. From a filled cell it stops at the last filled cell before a blank. From a blank cell it stops at the next filled cell. If nothing is in the way, it goes all the way to the edge of the sheet, which is row 1,048,576 or column XFD.

Selecting cells and ranges with the keyboard

Add Shift to any movement key and Excel selects instead of moving. Shift + Arrow extends the selection by one cell. Ctrl + Shift + Arrow extends it to the edge of the data block, so Ctrl + Shift + Down from a column header selects the whole column of data in one press. Ctrl + Shift + End selects from the active cell to the last used cell, and Ctrl + Shift + Home selects back to A1.

  1. Click, or move to, the top-left cell of the block you want.
  2. Press Ctrl + Shift + Down to select to the bottom of the block.
  3. Press Ctrl + Shift + Right to widen the selection to the last column.
  4. Press Ctrl + A instead if you want the whole contiguous region in a single press.

Ctrl + A behaves in two stages. Inside a block of data the first press selects the current region (the block bounded by blank rows and columns). A second press selects the entire worksheet. Ctrl + Shift + * (the asterisk on the main keyboard) always selects the current region only. Shift + Space selects the whole row and Ctrl + Space selects the whole column; inside an Excel Table, Ctrl + Space selects the Table column data first, then the header on a second press, and Ctrl + Shift + Space selects the whole Table before the whole sheet.

Two less known keys help when the block is irregular. F8 turns on Extend Selection mode: you can then move with the Arrow keys, or click, and the selection grows as if Shift were held. Shift + F8 turns on Add to Selection mode, which lets you build a multi-area selection without holding Ctrl. Press Esc to leave either mode. Ctrl + . (full stop) moves the active cell clockwise around the four corners of the current selection, so you can check its extent without scrolling.

Go To and Go To Special

F5 or Ctrl + G opens the Go To dialog. Type any address or named range, such as K2500 or Sales_2025, and press Enter. Type a range like A1:D200 to select it. The dialog remembers the cell you came from, so F5, Enter takes you straight back after a jump.

The Special button in that dialog (Alt + S while it is open) opens Go To Special, which selects cells by type inside the current selection or the used range: blanks, constants, formulas, comments, visible cells only, row or column differences, and precedents or dependents. Selecting blanks and then typing a value with Ctrl + Enter fills every gap at once. Two shortcuts bypass the dialog: Alt + ; selects visible cells only, which is essential before copying a filtered list, and Ctrl + [ selects the cells the active formula refers to (precedents) while Ctrl + ] selects the formulas that refer to the active cell (dependents).

The Name Box and named ranges

The Name Box sits to the left of the formula bar. Press Alt + F3 in Excel 365 or click it, type an address or a name, and press Enter to jump there. Type a range address to select it. Type a new name while a range is selected and press Enter to create a named range on the spot. Ctrl + F3 opens Name Manager to edit or delete names, and F3 pastes a name into a formula. Names combined with F5 or the Name Box give you one-keystroke access to any part of a large model.

Worked example: reaching the end of a column with a gap in it

Assume this small sales list in A1:C7. Note the blank cell in B5.

Row A: Region B: Units C: Revenue
1 Region Units Revenue
2 North 120 4,800
3 South 95 3,800
4 East 140 5,600
5 West 2,000
6 Central 60 2,400
7 Online 210 8,400
  1. Select B1 and press Ctrl + Down. Excel stops at B4, because B5 is blank. Press Ctrl + Down again and it lands on B6, the next filled cell, and a third press reaches B7.
  2. Select A1 and press Ctrl + Down. Column A has no gap, so Excel goes straight to A7.
  3. To select the whole block regardless of the gap, select A1 and press Ctrl + A once. The current region A1:C7 is selected, because the blank in B5 does not create a blank row or column.
  4. To select column B including the gap, select B1, press Ctrl + Shift + Down to reach B4, then press Ctrl + Shift + Down twice more. Each press extends to the next stop. On a long column a safer route is Ctrl + Shift + End from B1 then Shift + Left to drop column C.

Result: you can select any column, with or without gaps, in two to four keystrokes. The gap in B5 is exactly the kind of problem that makes Ctrl + Shift + Down stop early, so use Ctrl + A or the End key route when a column may contain blanks.

Navigation and selection shortcut reference

Action Windows Mac
Move one cell Arrow keys Arrow keys
Next / previous cell in the row Tab / Shift + Tab Tab / Shift + Tab
Down / up one cell after entry Enter / Shift + Enter Return / Shift + Return
Jump to the edge of the data block Ctrl + Arrow ⌘ + Arrow
Select to the edge of the data block Ctrl + Shift + Arrow ⌘ + Shift + Arrow
Extend the selection by one cell Shift + Arrow Shift + Arrow
Go to cell A1 Ctrl + Home Ctrl + Home or Fn + Ctrl + Left
Go to the last used cell Ctrl + End Ctrl + End or Fn + Ctrl + Right
Select to the last used cell Ctrl + Shift + End Ctrl + Shift + End
Select the current region / whole sheet Ctrl + A (press twice for the sheet) ⌘ + A
Select the current region only Ctrl + Shift + * ⌘ + Shift + *
Select the entire row Shift + Space Shift + Space
Select the entire column Ctrl + Space Ctrl + Space
Scroll one screen down / up Page Down / Page Up Fn + Down / Fn + Up
Scroll one screen right / left Alt + Page Down / Alt + Page Up Option + Fn + Down / Option + Fn + Up
Scroll back to the active cell Ctrl + Backspace ⌘ + Delete
Go To dialog F5 or Ctrl + G F5 or Ctrl + G
Select visible cells only Alt + ; ⌘ + Shift + Z
Select precedents / dependents Ctrl + [ / Ctrl + ] Ctrl + [ / Ctrl + ]
Extend Selection mode on / off F8 F8
Add to Selection mode Shift + F8 Shift + F8
Move around the corners of the selection Ctrl + . Ctrl + .
Name Manager Ctrl + F3 Ctrl + F3

Tips and common mistakes

  • Ctrl + Down went to row 1,048,576. The active cell was blank and there was no data below it, so Excel jumped to the sheet edge. Press Ctrl + Up to come back, or start from a filled cell.
  • Ctrl + End lands far below your data. Excel remembers cells that once held content or formatting. Delete the empty rows and columns below and to the right of the data, save the file, and Ctrl + End will reset.
  • Check the status bar for EXTEND or ADD. If every Arrow press grows the selection, you pressed F8 by accident. Press Esc.
  • Scroll Lock changes the Arrow keys. With Scroll Lock on, Arrow keys scroll the window instead of moving the cell. The status bar shows SCROLL LOCK; press the key again to turn it off.
  • Copying a filtered list copies hidden rows too, in some cases. Select the range, press Alt + ;, then Ctrl + C to be safe. This matters more for subtotalled or grouped rows than for AutoFilter.
  • Frozen panes change Ctrl + Home. It goes to the first cell below and right of the freeze line, not A1. Use the Name Box to reach A1 if you need it.
  • Use Ctrl + A once, not twice, before formatting. A second press selects the entire sheet, and formatting a million rows makes the file slow.

Practise these five this week

Shortcut What it does When to use it
Ctrl + Arrow Jumps to the edge of the data block Reaching the last row of any list
Ctrl + Shift + Arrow Selects to the edge of the data block Selecting a column of data before a formula or format
Ctrl + A Selects the current region, then the sheet Selecting a whole table for sorting, copying or a Table
Ctrl + Home / Ctrl + End Corners of the used range Getting back to the top, or checking how far the data goes
F5 Go To any address or name Jumping across large models and returning with F5, Enter
  1. Open any workbook with more than 100 rows. Get from A1 to the last row and back using only Ctrl + Down and Ctrl + Up.
  2. Select the entire data block with Ctrl + A, then with Ctrl + Shift + End from the first cell, and compare what each selects.
  3. Use F5 to jump to a cell 500 rows down, then F5, Enter to return without scrolling.

Key takeaways

  • Ctrl + Arrow moves to the edge of a data block; add Shift to select instead.
  • Ctrl + A selects the current region on the first press and the whole sheet on the second.
  • Blank cells stop Ctrl + Arrow early; use Ctrl + A or Ctrl + Shift + End when a column has gaps.
  • F5 and the Name Box jump to any address or named range and can select ranges by typing them.
  • Alt + ; selects visible cells only, which protects you when copying filtered or grouped data.

Related lessons

Frequently asked questions

Why does Ctrl + Down take me to row 1048576?

Because the active cell was empty, or it was the last filled cell in the column, and there is no more data below. Excel jumps to the next filled cell in that direction and, finding none, stops at the last row of the sheet. Press Ctrl + Up to return to the data, or start the jump from a cell inside the block.

How do I select to the last row without dragging?

Select the first cell of the column and press Ctrl + Shift + Down. If the column contains blank cells the selection stops at the first blank; press the combination again to extend past each gap, or use Ctrl + Shift + End from the first cell and trim extra columns with Shift + Left.

What does Ctrl + A do the second time you press it?

The first press selects the current region, meaning the block of filled cells around the active cell bounded by empty rows and columns. The second press selects the entire worksheet. If the active cell is already outside any data, a single press selects the whole sheet. Inside an Excel Table, the first press selects the Table data, the second adds the header, and the third selects the sheet.

How do I select only visible cells after filtering?

Select the filtered range, then press Alt + ; (semicolon). Only the visible cells stay selected, and Ctrl + C now copies just those rows. The same option is available through F5 > Special > Visible cells only. On a Mac use ⌘ + Shift + Z.

Is there a shortcut to jump to a specific cell in Excel?

Yes. Press F5 or Ctrl + G, type the address such as H500 or a named range, and press Enter. You can also click the Name Box, type the address and press Enter. Both methods accept range addresses like B2:F100, which are selected rather than merely reached.

Want the finished version? Ready-made Excel dashboards, trackers and VBA systems are available at NextGenTemplates.com.

All lessonsExcel Shortcut KeysNext →Excel Editing, Copy-Paste and Paste Special Shortcuts