Excel Shortcut to Select a Row

In Excel for Microsoft 365 on Windows, press Shift+Spacebar to select the entire worksheet row containing the active cell. On a Mac, the same shortcut works; in Excel for the web, use it while the worksheet grid has focus.

The shortcut and what it selects

Shift+Space selects a row across the worksheet, not just the cells that currently contain data. For example, if the active cell is D7, pressing the shortcut selects row 7, from the far-left edge of the worksheet to the far-right edge. The row heading at the left also appears highlighted, and the active cell remains within the selection.

The selection is a way to tell Excel which cells you want to work with; it does not itself change or remove anything. After selecting a row, you can apply formatting, copy its contents, hide it, or choose a deletion command. Excel waits for that separate action.

Select a row: Shift+Spacebar.
Select a column: Ctrl+Spacebar on Windows. On a Mac, the equivalent is Control+Spacebar, though macOS keyboard or input-source settings may reserve that shortcut.
Select the whole worksheet: use the Select All button at the corner where the row and column headings meet, or press Ctrl+A in many worksheet contexts.

These shortcuts are useful because they let you select a whole row without moving the pointer to the row headings. They also work when the row is wider than the portion of the sheet currently visible.

How to use Shift+Space

First, make sure Excel is ready to accept a worksheet command rather than text for a cell. Click a cell in the row you want, or use the arrow keys to move the active cell there. Then press and hold Shift and tap the spacebar. The row should become selected immediately.

Click any cell in the target row, such as B12.
Press Shift+Spacebar.
Check the row heading to confirm that row 12 is selected.
Choose the next operation, such as applying a fill color or opening the row heading’s context menu.

You do not need to start in the first or last used cell. If a record is spread across columns A through H, selecting from any cell in that record selects its worksheet row, including blank cells outside that range. This is especially helpful when you do not know the row’s full width or when the sheet extends well beyond the visible columns.

Selecting several rows

For a continuous block of rows, select the first row with Shift+Space, then hold Shift and press the Down Arrow to extend the selection one row at a time. Press the Up Arrow while holding Shift to extend it upward instead. You can also click the first row heading and Shift-click the last row heading; Excel selects the rows between them as one continuous block.

For example, to select rows 12 through 15 from the keyboard, select row 12 and press Shift+Down three times while keeping the selection active. Check the highlighted row headings before applying a change, especially if the active cell or selection has moved unexpectedly.

To select separate, nonadjacent rows, select one row and then Ctrl-click other row headings on Windows. On a Mac, use Command-click to add separate row headings. Nonadjacent selections are useful for applying the same formatting to a few records without affecting the rows between them. Some actions, such as copying a selection made up of separate areas, behave differently from actions on one continuous block, so check the result before relying on it.

Using the row headings instead

The keyboard shortcut is not the only way to select a row. Each worksheet row has a numbered heading along the left edge. Clicking a row number selects the entire worksheet row. To select a range, click the first row number and Shift-click the last. To add separate rows, use Ctrl-click on Windows or Command-click on Mac.

Row headings can be easier to use when you want to verify exactly which rows are selected, or when a keyboard shortcut is inconvenient. They are also a practical fallback if a laptop’s keyboard layout or another application intercepts a key combination. If the row numbers are not visible, the sheet may be scrolled horizontally or the headings may be hidden; use the keyboard shortcut or restore the headings through Excel’s View options.

Another option is to use the Name Box, located to the left of the formula bar. Enter a row reference such as 12:12 and press Enter to select row 12. A range such as 12:15 selects rows 12 through 15. This method is handy for distant rows that would otherwise require a long scroll, and it works with row ranges even when the target is outside the visible area.

What row selection changes—and what it does not

A selected row is not the same as a deleted row, a filtered-out row, or a row with its contents cleared. Selection only identifies cells for a later command. Pressing Delete on a selected row generally clears cell contents; it does not remove the worksheet row itself. To remove the row structure, right-click a selected row heading and choose Delete. To hide it, right-click the heading and choose Hide.

That distinction matters because a worksheet row can contain formulas, formatting, comments, or data validation as well as visible values. Clearing contents and deleting the row have different effects on the sheet’s layout and on references. If you are unsure which operation you need, make a copy of the workbook or use Undo promptly after an unintended change.

Once the row is selected, formatting commands apply across the selected row. For example, a fill color or number format can affect blank cells too, not just the populated cells. Copying a whole row can also copy formatting and other cell properties along with values. If you only want to change a record’s populated range, select that range of cells instead of the full row.

Excel tables and filtered data

When the active cell is inside an Excel table, Shift+Space may first select the table’s data row rather than every cell in the worksheet row. This keeps the selection aligned with the table, which is often what you want when working with a structured list. In some Excel table contexts, pressing Shift+Space again expands the selection to the entire worksheet row.

A table row is not the same thing as a worksheet row. A table may occupy only columns A through F, while the worksheet row continues across many more columns. If your goal is to format or copy only the table record, use the table-row selection. If you intend to delete or hide the entire worksheet row, verify that the row heading is selected before choosing the command.

Filters can make this distinction less obvious. A filtered table hides rows that do not meet the filter, but those rows still exist in the worksheet. Selecting visible table records does not mean that hidden records have been deleted. Before applying a change to filtered data, check whether the command should affect only visible cells or the full worksheet row; the appropriate selection can depend on the command and how the data is selected.

Windows, Mac, and Excel for the web

For desktop Excel on Windows, Shift+Space is the standard shortcut to select the row containing the active cell. In Excel for Mac, Shift+Space also selects the row. The primary shortcut is therefore the same across the two desktop versions, although other keyboard commands and system-level settings can differ.

On a Mac, if the shortcut seems not to work, confirm that the worksheet has focus and that Excel is not editing a cell. Also check macOS keyboard settings or utilities that may capture key combinations. You can always click the row heading instead. The Control+Space column-selection shortcut is more likely to conflict with Mac input-source settings; that issue does not change the row-selection shortcut.

Excel for the web supports common worksheet shortcuts, including Shift+Space, but the browser and worksheet must be in the right state. Click a cell in the grid first. If the shortcut is intercepted or does not produce the expected selection, use the row heading as a reliable alternative. Keyboard behavior can also vary with the browser, operating system, and whether a dialog or text field currently has focus.

Common problems and quick fixes

The spacebar types into a cell: Excel may be in cell-edit mode. Press Esc to cancel the edit, or Enter to accept it, then select the cell and try Shift+Space again.
Only part of a table row is selected: You may be seeing the table-row selection rather than the full worksheet row. Press Shift+Space again if your Excel context supports expanding it, or click the numbered row heading.
The wrong row is highlighted: The active cell may not be in the row you intended. Click a cell in the correct row first, then use the shortcut.
The shortcut does nothing: Click inside the worksheet grid, close any open menu or dialog, and try again. A browser, keyboard utility, or system setting may also be intercepting the key combination.
A command affects more than expected: A whole-row selection includes blank cells across the worksheet. Select only the used cells if the operation should be limited to a record or table range.

Frequently Asked Questions

What is the shortcut to select a row in Excel?
Press Shift+Spacebar while a cell in the target row is active. Excel selects the row containing that cell.

How do I select multiple rows in Excel with the keyboard?
Select the first row with Shift+Space, then hold Shift and press the Down Arrow to extend the selection. Use the Up Arrow to extend it toward earlier rows.

Does Shift+Space delete a row?
No. It only selects the row. To delete the worksheet row, right-click its row heading and choose Delete; pressing Delete on the keyboard generally clears contents instead.

How do I select a row on a Mac?
Click a cell in the row and press Shift+Space. You can also click the numbered row heading along the left side of the worksheet.

Why does Shift+Space select only part of a row?
If the active cell is inside an Excel table, the shortcut may select that table’s data row first. Use the shortcut again if it expands the selection in your context, or click the worksheet row number to select the full row.

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.