Excel Keyboard Shortcut to Select a Row in Any Worksheet

How-to basics · Updated November 19, 2026

In Excel for Microsoft 365 on Windows, press Shift+Space to select the entire worksheet row containing the active cell. If you are typing or editing a cell, press Esc first; otherwise, the keystroke may enter a space instead of selecting the row.

The shortcut and what it selects

Shift+Space is the direct keyboard shortcut for selecting a row. Start with a cell in the row you want, such as D7, and press the two keys together. Excel highlights the full row, from the first worksheet column through the last, rather than selecting only the cells containing data.

The selected row is useful when you want to apply an operation to all of its cells. For example, you can format a complete record, clear its contents, copy it, or delete the worksheet row. Selection does not itself change the data: the next command you choose determines what happens.

  • Shift+Space: select the row containing the active cell.
  • Ctrl+Space: select the column containing the active cell on Windows.
  • Click a row number at the left edge of the worksheet: select that row with the mouse.

How to use it step by step

  1. Click a cell anywhere in the row you need, or move the active cell there with the arrow keys.
  2. Make sure you are not editing the cell. If the insertion cursor is visible in the cell or formula bar, press Esc to leave edit mode.
  3. Press and hold Shift, then tap the spacebar. Release both keys.
  4. Check the row number at the left. The row should be highlighted across the worksheet.

For example, if the active cell is B12, Shift+Space selects worksheet row 12, including cells that currently appear blank. If you then press Ctrl+C, Excel copies the selected row. If you press Ctrl+- (Ctrl and the minus key), Excel opens the Delete dialog or deletes the selected row depending on the selection and Excel settings. Check the dialog before confirming, especially in a workbook with formulas or linked data.

What a selected row means in Excel

A selected worksheet row is different from a selection of only the visible data cells in that row. When you select a whole row, Excel includes every column in the worksheet, not just the columns used by your table. That distinction matters when copying or formatting: the selection may include cells far beyond the edge of the data you can see.

It also matters when deleting. Selecting cells in a data range and deleting them can shift nearby cells up or left. Selecting the row and choosing a delete-row command removes the entire worksheet row and shifts the rows below it upward. If you only mean to remove a record from a structured table, use the table’s row deletion option or confirm that deleting the worksheet row is appropriate.

Selection is not the same as hiding, filtering, or deleting. A highlighted row remains in the sheet until you perform an action. A filtered-out row is temporarily not displayed, and a hidden row remains in the worksheet but is not shown. These operations have different effects on formulas and data.

Selecting several rows

For adjacent rows, select the first row and extend the selection, or use the row headers. With the keyboard, press Shift+Space on a cell in the first row, then hold Shift and press the Up or Down arrow to extend the selection to neighboring rows. Watch the highlighted row numbers as you extend it; if the selection does not match what you intend, click a cell to reset it and try again.

The row headers are a clear alternative when selecting a large block. Click the number of the first row, then hold Shift and click the number of the last row. Excel selects the range between them, including both endpoints. You can also drag down or up across row numbers for a short block, though clicking the endpoints is often more controlled.

To select rows that are not next to each other, select one row and then hold Ctrl while clicking additional row numbers on Windows. On a Mac, use Command while clicking the additional row headers. Nonadjacent selections are useful for applying formatting to separate records, but not every command treats a multi-area selection exactly like one continuous block. Check the result before using a command that changes or removes data.

Rows inside an Excel table

Excel tables have their own selection behavior because a table row contains a defined set of columns, often with a header row and a total row. When the active cell is inside a table, Shift+Space can select the table’s data row rather than every cell across the worksheet. In many desktop versions, pressing the shortcut again expands the selection to the entire worksheet row.

This difference is helpful when you want to format or copy just one record without including thousands of empty worksheet cells. It can also be confusing if you expect the entire row to be selected on the first press. Look at the highlighted area: if it ends at the table’s last column, you have selected the table row. Press Shift+Space again if you specifically need the whole worksheet row, or click the row number to select it directly.

Do not confuse selecting a table row with deleting a worksheet row. To remove only a record from a table, right-click within that table row and choose Delete > Table Rows. The exact options shown can depend on where you right-click. For an entire worksheet row, use the row header’s context menu and choose Delete.

Related shortcuts and mouse alternatives

These shortcuts solve nearby tasks, but they do not all select the same thing:

  • Shift+Space selects the row containing the active cell.
  • Ctrl+Space selects the active cell’s column on Windows. If a table is active, its selection behavior may be limited to the table column.
  • Ctrl+A selects the current data region in many situations; pressing it again can expand the selection. It is not the direct shortcut for one worksheet row.
  • Clicking a row number selects a row without needing an active cell in the data.
  • Clicking and dragging across row numbers selects a continuous block of rows.

For a quick formatting task, selecting a row and using commands on the Home tab may be convenient. For example, use Home > Fill Color to apply a background color, or Home > Format to find row-height and visibility options. The shortcut only makes the selection; it does not choose a formatting command for you.

Windows, Mac, and Excel for the web

In Excel for Microsoft 365 on Windows, use Shift+Space. Excel for Mac also uses Shift+Space to select a row. The Mac column-selection shortcut is generally Control+Space, rather than Windows’ Ctrl+Space; macOS keyboard settings or input-source shortcuts can sometimes interfere with system-level key combinations. If a shortcut is intercepted, use the row header instead.

Excel for the web also supports common Excel keyboard shortcuts, including row selection, but browser and operating-system shortcuts can affect how a key combination behaves. If the shortcut does not work in the browser, click a cell in the row and try again, or click the row number. The row header method is also a dependable fallback in desktop Excel.

Common problems and fixes

  • A space appears in the cell: Excel is probably in cell-edit mode. Press Esc, then press Shift+Space again.
  • Only the table row is highlighted: You are likely inside an Excel table. Press Shift+Space again if you need the full worksheet row, or click its row number.
  • The wrong row is selected: The active cell was in a different row than expected. Check the cell address in the Name Box, or click a cell in the intended row before using the shortcut.
  • The shortcut seems to do nothing: Confirm that the worksheet is active and that a cell, rather than a shape or chart, has focus. On the web, check whether the browser is capturing the keystroke.
  • You want only cells with data: The shortcut is designed to select a row, not detect the used range. Select the cells you need by dragging or using the Name Box instead.

One common misconception is that Shift+Space selects every row that contains data. It selects the row associated with the active cell, even if some or most of that row is blank. To select all rows in a data set, first select the data range or use its table controls; do not assume one row-selection keystroke identifies the entire data set.

Frequently Asked Questions

What is the Excel shortcut to select an entire row?
Press Shift+Space while a cell in the desired row is active. In a table, the first press may select just the table row.

How do I select multiple rows with a keyboard?
Select a row with Shift+Space, then hold Shift and use the Up or Down arrow to extend the selection to adjacent rows. Check the highlighted row numbers before acting.

How do I select a row without a mouse?
Move the active cell to that row with the arrow keys or the Name Box, then press Shift+Space. The row header is an alternative when using a mouse or trackpad.

Does Shift+Space work in Excel on a Mac?
Yes. Excel for Mac uses Shift+Space for row selection as well. If a system shortcut or keyboard setting interferes, click the row number instead.

What is the shortcut to select a column?
On Windows, press Ctrl+Space with a cell in the desired column active. On Mac, the corresponding Excel shortcut is generally Control+Space.

Does selecting a row delete it?
No. Selection only highlights the row. To remove it, use a delete command, and confirm whether you intend to remove a worksheet row or only a table row.

Related

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.