Excel Row and Column Select Shortcut Keys Explained

How-to basics · Updated November 19, 2026

In Excel for Microsoft 365 on Windows, press Shift+Spacebar to select the entire row containing the active cell, or Ctrl+Spacebar to select its entire column. These shortcuts select worksheet rows and columns, not just the cells that currently contain data.

The two shortcuts at a glance

Click a cell in the row or column you want, then use the matching shortcut. The active cell is the selected cell with the prominent border; Excel uses its position to decide which row or column to highlight. You do not need to click the row number or column letter first.

  • Select a row: Shift+Spacebar.
  • Select a column: Ctrl+Spacebar.

For example, if D7 is active, Shift+Spacebar selects all of row 7, from column A through the last worksheet column. Ctrl+Spacebar selects all of column D, from the first worksheet row through the last. The selection can look larger than the visible grid because Excel includes cells that are currently blank.

These are selection commands, not deletion commands. Nothing is removed when you press either shortcut. To delete a selected row or column, use the relevant delete command separately, and check the selection before doing so.

What selecting a whole row or column means

An Excel worksheet is a grid with numbered rows and lettered columns. Selecting a whole row or column tells Excel to treat that complete grid line as the target for a later action. This is different from selecting a range such as A7:D7: a range contains only specified cells, while selecting row 7 includes every cell across the worksheet.

This distinction matters for formatting, copying, inserting, hiding, and deleting. If you select A7:D7 and apply a fill color, only those four cells receive it. If you select the entire row with Shift+Spacebar and apply a fill color, the formatting applies across row 7, including cells beyond the current data table. The same principle applies to a whole-column selection.

A full-row or full-column selection is useful when an operation should apply consistently beyond the data currently on screen. It can also be broader than intended. For instance, deleting a selected worksheet column removes every cell in that column, not only the cells in a small report. If you only mean to change a few values, select the specific range instead.

Selecting more than one row or column

To select a block of adjacent rows or columns, start with the single-row or single-column shortcut, then extend the selection using Shift and an arrow key. The active edge of the selection moves in the direction you choose.

  1. Click a cell in the first row you need and press Shift+Spacebar.
  2. Hold Shift and press Up Arrow or Down Arrow to add adjacent rows.
  3. For columns, click a cell in the first column and press Ctrl+Spacebar, then hold Shift and press Left Arrow or Right Arrow.

For example, to format rows 10 through 14, click a cell in row 10, press Shift+Spacebar, then hold Shift and press Down Arrow four times. To select columns C through F, click a cell in column C, press Ctrl+Spacebar, then hold Shift and press Right Arrow three times. Check the highlighted boundaries before applying a change.

For non-adjacent rows or columns, use the row numbers or column letters with Ctrl-click on Windows to add separate header selections. Keyboard selection is most straightforward for one continuous block. If you need to select several scattered areas, using the headers can make the intended targets easier to inspect.

How the shortcuts behave inside Excel tables

Excel tables have their own selection behavior. If the active cell is inside a formatted table, Ctrl+Spacebar can select the table column rather than the entire worksheet column. The selection is limited to the table’s column, which is often safer when you want to format or work with just that field. Pressing Ctrl+Spacebar again can expand the selection to the full worksheet column.

Similarly, Shift+Spacebar from a table cell can select the table’s data row rather than every cell in the worksheet row. In table context, pressing Shift+Spacebar again can extend the selection to the full worksheet row. The exact appearance depends on where the active cell is and whether the table includes a header or total row, so inspect the highlighted area before running a command.

This behavior is useful rather than a shortcut failure: tables are designed to keep actions focused on the structured data. If you specifically need the whole worksheet row or column, repeat the shortcut while the selection is active and verify that the row number or column letter is highlighted across the grid.

Mouse, ribbon, and name box alternatives

The shortcuts are fast, but other methods can be clearer when you are learning Excel or selecting a distant area. Clicking a row number at the left edge of the grid selects that worksheet row. Clicking a column letter above the grid selects that column. Dragging across adjacent row numbers or column letters selects a continuous block.

  • Header click: Click a row number or column letter for one whole row or column.
  • Header drag: Drag over neighboring headers to select multiple adjacent rows or columns.
  • Name Box: Click the Name Box to the left of the formula bar, type a reference such as 7:7 or C:C, and press Enter to select that full row or column.

The Name Box method is particularly useful for a row or column that is far from the visible area. A reference such as 7:9 selects rows 7 through 9; D:F selects columns D through F. It also avoids scrolling the worksheet just to reach a header. Use a specific cell range, such as C7:F9, when you do not intend to select complete worksheet lines.

Common problems and how to fix them

If a shortcut seems to do nothing, first check whether Excel is editing a cell. When the insertion point is inside the formula bar or cell text, keyboard input may edit the contents rather than control the worksheet. Press Esc to cancel the edit, or Enter to commit it, then click the target cell and try again.

Another common source of confusion is using the wrong modifier. On Windows, Ctrl+Spacebar selects a column; Shift+Spacebar selects a row. The Ctrl key is not interchangeable with Shift here. Also make sure the active cell is in the line you intend to select: selecting a row does not automatically move the active cell to the row above or below.

Selections can also appear incomplete when the worksheet is scrolled or zoomed. Excel may show only part of a full row or column on screen, even though the selection covers the entire line. Look at the row number or column letter and the shaded grid cells to confirm. A hidden row or column may not be obvious, so check neighboring headers if you suspect one is missing.

If a command affects more cells than expected, undo it immediately with Ctrl+Z when the action supports undo, then reselect a narrower range. A whole-column selection includes blank cells and any data farther down the worksheet. Before clearing or deleting, read the command and confirm whether you mean to clear cell contents, remove formatting, or delete the worksheet row or column.

Windows, Mac, and Excel for the web

In Excel for Microsoft 365 on Windows, use Shift+Spacebar for a row and Ctrl+Spacebar for a column. In Excel for Mac, Shift+Spacebar selects a row and Control+Spacebar selects a column. Mac keyboards label the key Control, and it is not the same as Command for this shortcut.

On some Macs, Control+Spacebar is also assigned by macOS to switch input sources. If Excel does not select the column, check the macOS keyboard shortcuts for input sources and change the conflicting system assignment, or use the column header as an alternative. The available system settings can vary by macOS version and language setup.

Excel for the web runs in a browser, so browser or operating-system shortcuts can sometimes affect what happens when a key combination is pressed. If the shortcut is intercepted or behaves differently, click the row number or column letter. That selection method is also useful when working with a touch device or a keyboard layout that makes the modifier combination awkward.

Choosing the right selection for the job

Choose a whole row or column when the action should apply across that worksheet line, such as setting a consistent row height, applying column-wide formatting, or inserting a complete row or column. Choose a cell range when the action should stop at the edges of a particular table or report. The smaller selection is usually safer for clearing data or applying changes to a workbook with unrelated content elsewhere.

For example, if a worksheet has sales data in columns A through F but notes in column H, selecting column C is appropriate for formatting the entire date field. Selecting C2:C50 is more controlled if only the current report’s records should change. If you want to add a new worksheet row between two records, selecting the entire row by its header or shortcut makes the insertion point unambiguous.

A practical check is to ask whether new or distant cells should receive the same action. If yes, a whole-row or whole-column selection may fit. If no, select only the data range you need. This small distinction prevents accidental formatting changes and makes destructive actions easier to review.

Frequently Asked Questions

What is the shortcut to select an entire row in Excel?
Click a cell in the row and press Shift+Spacebar on Windows. On Mac, use the same shortcut. If the cell is inside an Excel table, the first press may select only the table row.

What is the shortcut to select an entire column in Excel?
Click a cell in the column and press Ctrl+Spacebar on Windows. On Mac, press Control+Spacebar. Within a table, the first press may select the table column rather than the full worksheet column.

How do I select multiple rows or columns with the keyboard?
Select the first row with Shift+Spacebar, then hold Shift and press Up or Down to extend it. For columns, select the first one with Ctrl+Spacebar, then hold Shift and press Left or Right.

Why does Ctrl+Spacebar select only part of a column?
If the active cell is in an Excel table, the shortcut can select that table’s column only. Press Ctrl+Spacebar again to expand the selection to the worksheet column, and confirm the highlighted area before making changes.

Does selecting a row or column delete anything?
No. The shortcut only selects cells. Deletion happens only after you choose a delete command or press a deletion key, so verify the selection before taking that next step.

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.