How to Select Ranges Fast in Excel (Keyboard Tricks)

The most useful select range Excel shortcut is Ctrl+Shift+Arrow (⌘⇧Arrow on a Mac): it selects from the active cell to the last filled cell in one press. Add Shift+Arrow for small adjustments, Ctrl+A for a whole table and Shift+Space for a row, and you will rarely need to drag with the mouse again. This guide is for beginners who want to work faster, including on a Mac laptop.

Select range Excel shortcut cheat sheet#

Here are the selection shortcuts worth learning, with the Windows and Mac keys side by side. Mod means Ctrl on Windows and ⌘ (Command) on a Mac.

The one rule to remember: Shift + any move = select. Any key that moves the cursor will select instead if you hold Shift.

How to select a range with Shift and the arrow keys#

Hold Shift and press an arrow key: the selection grows one cell per press instead of moving. Start on C2 and press Shift+Right once. You now have C2:D2. Press Shift+Down once more and you have C2:D3, four cells, no mouse.

With the mouse, the same rule works: click the first cell, then hold Shift and click the last cell. This is often easier than dragging, because you can scroll between the two clicks.

How to select to the end of your data (Ctrl+Shift+Arrow)#

Ctrl+Shift+Arrow (⌘⇧Arrow on a Mac) selects from the active cell to the last filled cell in that direction. On a list of 18 orders, click C2 (the first Units cell) and press Ctrl+Shift+Down. Excel selects C2:C19, every unit in the column. Press Shift+Right and the Price column joins: C2:D19, 36 cells in two key presses.

It works the same way as the jump shortcut Ctrl+Arrow (⌘Arrow), which moves to the edge without selecting. You can learn the jump first in the jump to the edge of your data lesson.

One warning: the jump stops before an empty cell. If B10 is blank, Ctrl+Shift+Down from B1 selects only down to B9. That's annoying when you want the whole column, but useful for finding gaps. Press the shortcut again to carry on past the gap.

How to select a whole table, row or column#

Ctrl+A (⌘A) selects the whole table around the active cell. Click any cell inside your data first. Press Ctrl+A a second time to select the entire sheet. If the active cell is empty and away from your data, the first press already selects the whole sheet.

• Whole row: Shift+Space selects the row of the active cell, on Windows and Mac.
• Whole column: Ctrl+Space on Windows. On a Mac, Excel lists ⌃Space, but macOS often uses Control+Space to switch the keyboard language first. The safe way is to click the column letter at the top of the grid.

Mac users meet several small differences like this one. The Excel on Mac vs Windows guide covers the rest.

How to select cells that are not next to each other#

Hold Ctrl (⌘ on a Mac) and click or drag to add another range to the selection. For example, select A1:A7, then hold Ctrl and drag over C1:C7. Both columns stay selected, so you can make them bold together.

On the keyboard, press Shift+F8 to add another range, then use the arrow keys and Shift to select it. On a Mac laptop, you may need to hold fn for F8.

How to select a range by typing it in the Name Box#

For a very large range, type it. Click the Name Box (the box above column A that shows the cell name), type a range such as C2:C500 and press Enter. Excel selects all 499 cells at once, with no scrolling.

You can also type C:C for a whole column or A2:A10,C2:C10 for two separate ranges. There are more ideas in six Name Box tricks beginners miss.

How to select a range inside a formula#

The same keys work while you write a formula. Type =SUM(, click the first number, then press Ctrl+Shift+Down (⌘⇧Down). Excel writes the whole range into the formula for you. Type ) and press Enter.

This is faster and safer than typing the range by hand, because you can see exactly which cells you picked. If formulas are new to you, read how to write your first Excel formula first, and the Excel order of operations once you start combining + and *.

Common selection mistakes#

A few mistakes cause most selection problems:

• Blank cells in the data. Ctrl+Shift+Arrow stops at the first gap. Look at the highlighted cells, or the Count in the status bar at the bottom of the window, to check what you selected.
• Starting in the wrong cell. The selection always starts from the active cell. Start on the first data cell, not the header, when you want numbers only.
• Letting go of Shift too early. Without Shift, the arrow key moves the cursor and the selection is lost.
• Selecting while editing. If a cell is in edit mode (a blinking cursor), Shift+Arrow selects text inside the cell. Press Enter or Esc first.

Fast selection is one of the habits people notice when they watch you work. Here are the Excel shortcuts interviewers notice in a skills test.

Practise selecting ranges#

Shortcuts only stick when your fingers learn them. Open the select ranges with Shift lesson to practise Shift+Arrow, Ctrl+Shift+Arrow, Ctrl+A and row and column selection in a live sheet. Then try the jump to the edge of your data lesson to find gaps in a long list. After that, learn to move around Excel with the keyboard.