Excel Keyboard Shortcuts to Select Cells and Ranges

In Excel for Microsoft 365 on Windows, use Ctrl+A to select the current data region, then press it again to select the whole worksheet; use Shift with the arrow keys to extend a selection, Shift+Space for a row, and Ctrl+Space for a column. The right shortcut depends on whether you want nearby data, an entire row or column, or a particular range.

What selection shortcuts do

A selection is the cell or group of cells Excel acts on next. Many commands—such as formatting, copying, deleting, or applying a number format—operate on the selected cells. A selection shortcut changes which cells are highlighted; it does not, by itself, change their contents. The active cell is the cell within the selection where an entry would go, and Excel usually shows it with a heavier border.

Excel has several different ideas of a useful selection. A contiguous range is a block of neighboring cells, such as B2:D8. A current region is a block of data bounded by blank rows and columns. A worksheet selection can include every cell on the sheet, while a noncontiguous selection contains separate areas. Knowing which kind you need makes it easier to choose a shortcut and understand why a key combination sometimes selects more—or less—than expected.

Quick reference for common selections

Shift+Arrow key: extend the selection one cell at a time in the arrow’s direction.
Ctrl+Shift+Arrow key: extend the selection to the edge of the current data region in that direction.
Ctrl+A: select the current region; press again to select the whole worksheet when working in a data region.
Shift+Space: select the entire row containing the active cell.
Ctrl+Space: select the entire column containing the active cell.
Ctrl+Shift+End: extend the selection to the last used cell on the worksheet.
Ctrl+Shift+Home: extend the selection to cell A1.
Alt+;: select only visible cells within the current selection, useful with filtered or hidden data.

These are Windows shortcuts. Excel for Mac uses some different modifier keys, and macOS or another application can intercept certain combinations. Mac alternatives and a menu-based option are covered below.

Select a range by extending from one cell

Click a starting cell, then hold Shift and press an arrow key to include adjacent cells. For example, if B2 is active, pressing Shift+Right Arrow selects B2:C2. Pressing it again extends the selection to D2. The same method works vertically and in reverse: Shift+Left Arrow contracts or extends the selection toward the left, depending on the active cell and current boundary.

For a larger uninterrupted block, hold Ctrl+Shift and press an arrow key. If B2 contains data and the cells below it are filled continuously through B20, Ctrl+Shift+Down Arrow extends the selection to the bottom of that run. If the path encounters a blank cell, Excel stops at the edge of the uninterrupted region. This is why the shortcut can stop early in a table with gaps, or reach farther than expected when neighboring cells are populated.

To select from the active cell to a worksheet boundary, use Ctrl+Shift+End to extend toward the last used cell, or Ctrl+Shift+Home to extend toward A1. The last used cell is determined by worksheet content or formatting, so it may be farther down or across than the visible data table. If the selection seems enormous, press Ctrl+End by itself to see where Excel considers the used area to end.

Select a current region or the whole worksheet

When the active cell is inside a block of data, Ctrl+A selects that current region: the connected block of cells around the active cell, bounded by blank rows and columns. For example, if A1:D50 contains a continuous table and F1 is blank, placing the active cell in the table and pressing Ctrl+A generally selects the table’s region. A second press selects the whole worksheet. If the active cell is not inside a data block, the first press may select the worksheet directly.

Selection behavior can vary when the active cell is inside an Excel table, a PivotTable, or a specially structured range. In a table, repeated presses can move through table-related selections before reaching the whole sheet. Check the highlighted cells after each press rather than assuming every context follows the same sequence. Ctrl+Shift+Space is another way to select the current region around the active cell; repeated use can expand the selection in some worksheet contexts.

To select every cell regardless of where you are, click the Select All button at the top-left corner of the worksheet, where the row numbers and column letters meet. This is a useful fallback if keyboard behavior is ambiguous. Selecting the whole sheet does not mean every blank cell contains data; it means the worksheet grid is selected.

Select entire rows and columns

Place the active cell in the row you want, then press Shift+Space to select that entire worksheet row. Press Ctrl+Space to select the entire column. These shortcuts select the full row or column, not just the cells currently visible on screen. That distinction matters before applying formatting, clearing contents, or inserting or deleting cells.

To select several adjacent rows or columns, first select one and then extend the selection with Shift and an arrow key. You can also click a row number or column letter, then drag across neighboring headers. For separated rows or columns, hold Ctrl while clicking additional headers on Windows. Use noncontiguous selections carefully: some Excel commands do not work on multiple separate areas in the same way they work on one rectangular block.

When a shortcut appears to select a different object, check whether the cell is inside a table or whether focus is in the formula bar, a dialog box, or another application. The shortcut acts on the part of Excel that currently has focus; clicking a worksheet cell first usually restores the expected context.

Select separate ranges and visible cells only

To select nonadjacent cells or ranges on Windows, select the first area, then hold Ctrl while dragging over another area or clicking additional cells. For example, you can select A2:A10 and then, while holding Ctrl, select C2:C10. The two areas remain separate rather than becoming one rectangle. If you accidentally replace the first selection, start again and keep Ctrl held while adding each additional area.

Filtered lists create a related problem: a normal selection can include rows hidden by the filter. To work with visible cells only, first select the relevant range and press Alt+;. Excel then narrows the selection to visible cells in that range. This is particularly useful before copying a filtered list, because it helps avoid including hidden rows in the copied selection. It does not remove the filter or unhide rows; it changes which cells within the selection are targeted.

You can also use the Go To Special dialog when a shortcut is unavailable or easy to forget. Press Ctrl+G or F5, choose Special, and select an option such as Visible cells only. The exact options presented depend on the worksheet context. This dialog is also a practical route for selecting blanks, formulas, or other cell types without manually inspecting every cell.

Choose between shortcuts, the Name Box, and Go To

Keyboard selection is fastest when the desired cells are next to each other or follow a predictable data boundary. For a precisely specified address, the Name Box—the field to the left of the formula bar—is often more reliable. Click it, type a reference such as B2:D25, and press Enter to select that range. You can enter a single cell, a rectangular range, or a named range if the workbook defines one.

Go To is useful when you know the address but do not want to move to the Name Box. Press Ctrl+G or F5, enter a cell or range reference, and press Enter. For example, entering D100:D150 selects that range even if it is not visible on screen. Unlike Ctrl+Shift+Arrow, a typed reference does not depend on blank cells or the shape of nearby data.

Use Shift+Arrow for a small, exact extension.
Use Ctrl+Shift+Arrow when the data is continuous and you want to follow its edge.
Use the Name Box or Go To for a known address or an exact range.
Use row and column headers when you want a whole worksheet row or column.
Use Alt+; when hidden or filtered rows must be excluded from the selected cells.

Windows, Mac, and Excel for the web

The shortcuts above are for Excel for Microsoft 365 on Windows. On a Mac, selection shortcuts can use Command where Windows uses Ctrl, but not every shortcut maps directly, and macOS can reserve key combinations. Excel for Mac commonly uses Shift+Arrow to extend a selection and Shift+Space to select a row; column-selection and whole-region shortcuts can depend on the Mac keyboard and Excel version. If a combination is intercepted, use the worksheet’s row or column headers, the Name Box, or Home ribbon commands instead.

Excel for the web runs inside a browser, so browser shortcuts may conflict with Excel shortcuts, and some key combinations can vary by browser or operating system. The Excel web interface provides keyboard-shortcut help, and the ribbon or Name Box offers a dependable alternative when a key combination does not behave as it does in desktop Excel. If an instruction is for Windows desktop, do not assume that the same keystrokes will work unchanged in a Mac browser.

Common selection problems and fixes

Ctrl+Shift+Arrow stops too soon: a blank cell may interrupt the continuous region. Use the Name Box or Go To to specify the full range.
Ctrl+A selects only part of the sheet: the active cell may be inside a data region or table. Press it again, or use the Select All corner button.
The selection reaches far beyond the visible table: formatting or old content may make distant cells part of the used area. Check Ctrl+End and inspect the cells Excel reaches.
A shortcut types into a cell or changes something else: focus may be in a dialog, formula bar, browser, or another program. Click a worksheet cell and try again.
Hidden rows are included: select the range, then use Alt+; on Windows for visible cells only.

Before deleting or overwriting data, look at the highlighted outline and the Name Box reference to confirm the selection. A row or column shortcut affects the entire worksheet row or column, so a command intended for a small table can have a much wider effect if the wrong selection type is active.

Frequently Asked Questions

What is the shortcut to select all cells in Excel?
On Windows, press Ctrl+A. When the active cell is in a data region, the first press may select that region; press it again to select the whole worksheet. The Select All corner button is a direct alternative.

How do I select a range without using the mouse?
Move to the starting cell, then use Shift with the arrow keys to extend the selection. For a continuous block, use Ctrl+Shift with an arrow key. If you know the exact address, enter it in the Name Box or the Go To dialog.

How do I select an entire row or column?
On Windows, place the active cell in the row and press Shift+Space, or place it in the column and press Ctrl+Space. Clicking the row number or column letter also selects the whole row or column.

How can I select only visible cells in a filtered list?
Select the range, then press Alt+; in Excel for Windows. Alternatively, open Go To Special with Ctrl+G or F5, choose Special, and select Visible cells only.

Why does Ctrl+A not select the entire worksheet immediately?
Excel uses the active cell and surrounding data to determine whether a current region is the more relevant selection. If the first press selects the data block, press Ctrl+A again or click the Select All button to select the entire worksheet.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.