Excel Keyboard Shortcut to Select an Entire Row Fast

In Excel for Microsoft 365 on Windows, press Shift+Space to select the entire worksheet row containing the active cell. If the cell is inside an Excel table, the first press selects the table row; press the shortcut again to select the full worksheet row.

How to select a row with the keyboard

First make sure a worksheet cell is active and Excel is not editing its contents. Then press and hold Shift, tap the spacebar once, and release both keys. Excel highlights the row across the worksheet, and its row number at the left is highlighted as well. You can now apply an action to the selected row, such as formatting it or copying its contents.

Click a cell in the row you want, or use the arrow keys to move the active-cell outline there.
Press Shift+Space.
Check the row number at the left edge to confirm that the whole row, rather than just the cell, is selected.

The shortcut works from any column in the target row. For example, if the active cell is G12, Shift+Space selects row 12. You do not need to move to column A first. In a standard worksheet, the selection spans every column in that row, including currently empty cells.

What selecting an entire row means

A worksheet row is larger than the portion of the sheet that contains visible data. Modern Excel worksheets have 1,048,576 rows and 16,384 columns, so selecting row 12 means selecting all cells from A12 through XFD12—not merely the cells currently filled in. The row header also becomes highlighted, making the selection easy to distinguish from a single active cell.

This matters when applying an operation. Formatting a selected row can affect cells well beyond the edge of a small data table. Similarly, copying a whole worksheet row carries the row’s cells, including blank cells, rather than only the populated part of a record. If you only mean to work with a table record or a short range, selecting that smaller area may be safer and more precise.

Selection itself does not change data. Pressing Shift+Space is not the same as deleting, inserting, or hiding a row; it only changes which cells are selected. The next command determines what happens to them.

Behavior inside an Excel table

Excel tables have their own row boundaries, so the shortcut can behave differently when the active cell is inside one. The first press of Shift+Space selects the table’s data row—the record within the table. A second press selects the entire worksheet row containing that record. This distinction helps avoid selecting thousands of unrelated blank cells when you are working with a structured table.

For example, suppose a table occupies A1:D20 and the active cell is C8. The first press selects the table record in row 8 across the table’s columns. The second press expands the selection to the full worksheet row 8. If you are not sure which selection you have, look at the highlighted area: a table-only selection stays within the table’s boundaries, while a worksheet-row selection extends across the sheet.

Table selection is useful when formatting or copying one record without touching cells outside the table. If your goal is to apply a worksheet-wide action, use the second press or click the row number at the left. Table features and context can affect selection details, so check the highlighted area before taking an action that changes or removes content.

Selecting multiple whole rows

To select a continuous block of worksheet rows, use the row headers at the left edge: click the number of the first row, then hold Shift and click the number of the last row. Excel selects every row between them, inclusive. This is a practical method when the active cell is in a table or when you want to see the exact block before formatting, copying, or deleting it.

You can also select a row range through the Name Box, the small reference field to the left of the formula bar. Click in the Name Box, enter a reference such as 5:9, and press Enter. Excel selects rows 5 through 9 across the worksheet. This is handy for a large block that would take many clicks to reach. To select one whole row this way, enter a reference such as 12:12.

For nonadjacent rows, use the row headers and hold Ctrl while clicking additional row numbers on Windows. This adds separate rows to the selection without including the rows between them. Be deliberate with multi-row selections: an operation such as pressing Delete or applying a fill can affect every selected row, including any blank cells in those rows.

Related row and column shortcuts

The row shortcut is easy to confuse with the shortcut for selecting a column. In Excel for Windows, Shift+Space selects a row, while Ctrl+Space selects the entire column containing the active cell. For example, if D6 is active, the first selects row 6 and the second selects column D.

Neither shortcut is the same as selecting a cell range. To select a rectangular area, click the starting cell and hold Shift while using the arrow keys, or drag across the cells. If you want only the data region around the active cell, Excel also has navigation shortcuts for moving through data, but those do not mean the same thing as selecting a complete worksheet row.

Shift+Space: select the active cell’s row.
Ctrl+Space: select the active cell’s column.
Click a row number: select that worksheet row with the mouse.
Enter a row reference such as 5:9 in the Name Box: select a block of whole rows.

Remember that the selected row is not automatically the same thing as a row in a table, a filtered list, or a visible-only selection. If a worksheet has hidden or filtered rows, inspect what is highlighted and consider how the particular command you plan to use treats hidden cells.

Using the selection for common tasks

Once a whole row is selected, you can use Excel’s ribbon or other commands to format it, copy it, or perform another operation. The shortcut does not execute any of those commands by itself. For instance, selecting row 8 and then choosing a fill color changes its formatting; selecting row 8 and copying it places the selected row on the clipboard. Before deleting or overwriting anything, confirm that you selected the intended row.

A common misconception is that selecting a row and pressing Delete removes the row from the worksheet. In Excel, the Delete key generally clears cell contents; it does not remove the worksheet row structure. To remove a row, use the row’s context menu or an insert/delete command. Likewise, selecting a row does not insert a new row: selection and structural changes are separate actions.

For a narrow table, selecting just the data cells can be preferable to selecting the whole row. For example, if a record spans columns A through D and columns E onward contain unrelated notes, select only the table cells before copying or clearing. The full-row shortcut is most useful when the intended action really applies across the worksheet row.

Common problems and quick fixes

If Shift+Space appears to type a space instead of selecting a row, Excel may be in cell-edit mode. This can happen after pressing F2 or double-clicking a cell. Press Enter to commit the edit or Esc to cancel it, then try the shortcut again. If a formula bar or cell is still accepting text, Excel may treat the spacebar as text input.

If only part of a table row is selected, that is often the expected first-press behavior inside a table. Press Shift+Space a second time to select the worksheet row. If no selection appears, click a worksheet cell first and confirm that the worksheet has focus; a dialog box or another application may be receiving the keystrokes instead.

Also check the keyboard itself. On some compact keyboards, the spacebar or modifier keys may be difficult to press together, and remote desktop or browser setups can intercept shortcuts. Try pressing and holding Shift before tapping the spacebar, or use the row header as a dependable alternative. Avoid pressing Ctrl+Space by mistake, since that selects a column rather than a row.

Excel on Mac and Excel for the web

In Excel for Mac, the row-selection shortcut is also Shift+Space. The key combination for selecting a column may differ in practice because macOS and keyboard settings can use Control or other keys for system functions, so consult Excel’s shortcut list if you need the column equivalent. The row shortcut itself does not require replacing Shift with Command.

Excel for the web also supports keyboard selection, but the browser can reserve some key combinations, and behavior can depend on the browser and keyboard configuration. If Shift+Space does not work there, click the row header or use the Name Box to enter a row reference. In all versions, check the highlighted area before running a destructive command.

Frequently Asked Questions

What is the shortcut to select an entire row in Excel?
Press Shift+Space in Excel for Windows. The active cell determines which row is selected.

How do I select multiple rows at once?
For adjacent rows, click the first row number and Shift-click the last. You can also type a range such as 5:9 in the Name Box and press Enter.

Why does Shift+Space select only part of my row?
If the active cell is inside an Excel table, the first press selects the table’s data row. Press the shortcut again to expand the selection to the full worksheet row.

Does selecting a row delete it?
No. Selection only marks the cells. The Delete key clears contents; removing the row itself requires a separate delete-row command.

What is the Mac shortcut to select a row?
Use Shift+Space in Excel for Mac, as on Windows. If you are using Excel in a browser, try the row header if the browser intercepts the keystroke.

How do I select a whole column instead?
In Excel for Windows, press Ctrl+Space while a cell in that column is active. This is the column counterpart to Shift+Space.

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.