Excel Shortcut to Select All Rows in a Column at Once

How-to basics · Updated November 19, 2026

In Excel for Microsoft 365 on Windows, press Ctrl+Spacebar to select the entire column containing the active cell, including all its rows. Click a cell in the column first; if you mean only the filled cells in a data range, use a different selection method because Ctrl+Spacebar also selects blank cells.

The shortcut and what it selects

Ctrl+Spacebar selects a complete worksheet column, from the top row to the bottom row, rather than just the cells with visible values. In a modern Excel worksheet, that means a selection of 1,048,576 cells in that column. For example, click B7 and press Ctrl+Spacebar: Excel highlights column B, even if only B1:B200 contains data.

The active cell determines which column is selected. If the active cell is C12, the shortcut selects column C. You do not need to start at the first row, select the existing data, or click the column letter. This is useful when you want to format a whole column, set its width, or apply an operation to every cell in it.

Selection is not the same as an action: pressing the shortcut does not delete, copy, or change anything. It only marks the cells. What happens next depends on the command you choose, such as applying a number format or pressing Delete.

How to select a column with the keyboard

  1. Click any cell in the column you want to select.
  2. Press Ctrl+Spacebar on a Windows keyboard.
  3. Check that the column is highlighted, then choose the next command.

For instance, to select every cell in column D, click D5 and press Ctrl+Spacebar. To make the column wider afterward, move the pointer to the boundary between the D and E column headings and drag. You can also use the ribbon command Home > Format > Column Width to set a specific width.

If Excel is currently editing the contents of a cell, the shortcut may not select the column. Press Enter or Esc to leave edit mode, click the cell again, and retry. Likewise, make sure the worksheet—not a text box, formula bar, or another control—has keyboard focus.

Use the column heading as a mouse alternative

Clicking the column letter at the top of the worksheet selects that entire worksheet column. For example, click the heading E to select all of column E. This is a reliable alternative if you cannot remember the shortcut, if a keyboard shortcut is intercepted, or if you want to confirm visually which column you are selecting.

To select several neighboring columns, click the first column heading and drag across the headings to the last one. You can also click the first heading, hold Shift, and click the last heading. Excel highlights the columns between them. For nonadjacent columns, hold Ctrl while clicking additional headings on Windows; on Mac, use Command while clicking.

Column headings are useful when the active cell is hard to identify or when a selection needs to be obvious before you format or clear it. Avoid clicking the small square at the worksheet’s upper-left corner unless you intend to select the whole worksheet; it sits where the row and column headings meet.

Whole column versus filled cells only

A common source of confusion is the difference between selecting a worksheet column and selecting the portion of a column that contains data. Ctrl+Spacebar selects the whole column, including empty cells above, below, and between the data. That broad selection is often appropriate for formatting, but it may be unnecessary when copying or editing a short list.

For a continuous block of data, click its first cell and press Ctrl+Shift+Down to extend the selection toward the bottom edge of the current data region. This can stop at a blank cell, so inspect the highlighted range when the list contains gaps. If the data begins in A2 and runs without gaps through A100, starting at A2 and using this shortcut selects the contiguous entries down the column.

For an exact range, select it through the Name Box: click the box to the left of the formula bar, type a reference such as A2:A100, and press Enter. That selects only those cells, regardless of whether other content exists elsewhere in column A. This approach is more predictable when the column has blank rows or when you know the precise endpoints.

What changes inside an Excel table

Excel tables have their own selection behavior. If the active cell is inside a formatted table, Ctrl+Spacebar may first select the table’s data cells in that field rather than the entire worksheet column. Pressing the shortcut again can expand the selection to the table column, and another press can select the worksheet column. The exact visible boundary matters, so check the highlight before applying a broad change.

This distinction is helpful because a table column is a defined field, often with a header such as “Date” or “Amount,” while a worksheet column continues far beyond the table. If your goal is to work only with the table’s records, a table-column selection may be the safer and more relevant choice. If you specifically need every cell in the worksheet column, continue the shortcut sequence until the column heading and full worksheet column are selected.

You can also click the table’s header cell to work with that field, but be aware that a header cell is not the same thing as selecting the entire worksheet column. Before clearing or formatting, confirm whether the selected area includes the table header, total row, or cells outside the table.

Related shortcuts and how they differ

Several Excel shortcuts sound similar but select different areas. The right one depends on whether you want a column, row, data region, or entire sheet.

  • Ctrl+Spacebar: selects the column containing the active cell.
  • Shift+Spacebar: selects the entire row containing the active cell.
  • Ctrl+A: selects the current data region in many worksheet contexts; pressing it again can select the whole worksheet. Inside a table, Ctrl+A has table-specific selection behavior.
  • Ctrl+Shift+Down: extends a selection down through a contiguous data region, rather than selecting every cell in the worksheet column.
  • Ctrl+Shift+End: extends a selection to the last used cell on the worksheet, which may be in another column.

For example, if you click C4 and press Shift+Spacebar, Excel selects row 4 across the worksheet. If you press Ctrl+Spacebar instead, it selects column C. Neither shortcut means “select only the nonblank cells in this row or column”; they select the corresponding worksheet structure, subject to table behavior.

Mac and Excel for the web

In Excel for Microsoft 365 on Mac, the column-selection shortcut is generally Control+Spacebar, not Command+Spacebar. Command+Spacebar is commonly assigned to macOS Spotlight, so it is not the equivalent for selecting a column in Excel. On some Macs, Control+Spacebar may conflict with a macOS input-source shortcut. If it does, use the column heading, or change the conflicting macOS keyboard shortcut in System Settings.

Excel for the web runs in a browser, where keyboard combinations can sometimes be intercepted by the browser or operating system. If Ctrl+Spacebar does not select the column, click its letter heading instead. The heading method works without relying on the browser passing the key combination to Excel.

Shortcut behavior can also depend on focus. If a cell is being edited, a browser control is active, or the sheet is in a special selection state, the keystroke may not have the expected effect. Click a worksheet cell and look for the column highlight before proceeding.

Common problems and safe ways to proceed

If Ctrl+Spacebar appears to do nothing, first click a normal worksheet cell and exit cell-editing mode. Then verify that the keyboard layout and operating system have not assigned the combination to another feature. On a Mac, the system input-source shortcut is a frequent explanation; in a browser, the heading click is a straightforward workaround.

If only part of a table column is highlighted, that may be Excel’s table-selection sequence rather than a failure. Press Ctrl+Spacebar again and inspect the selection after each press. If your goal is a precise set of records, do not keep expanding the selection automatically—use the table range or select the exact cells you need.

Be especially careful before pressing Delete, applying a fill color, or pasting. A full-column selection includes blank cells and cells outside a small data list. Pressing Delete clears cell contents in the selected cells, while formatting changes can affect cells where you did not expect them. For a list that occupies A2:A100, selecting that range is often safer than selecting all of column A.

Frequently Asked Questions

What is the Excel shortcut to select an entire column?
Click a cell in the column and press Ctrl+Spacebar in Excel for Microsoft 365 on Windows. Excel selects the whole worksheet column, not just its populated cells.

How do I select all rows in one column without using the mouse?
Click any cell in the target column and press Ctrl+Spacebar. This selects every row position in that column, including blank cells.

What is the shortcut to select an entire row?
Click a cell in the row and press Shift+Spacebar on Windows. This selects the worksheet row; Ctrl+Spacebar selects a column instead.

How do I select only the cells with data in a column?
For a continuous range, start at its first cell and use Ctrl+Shift+Down to extend through the contiguous data region. Because blank cells can interrupt the selection, use the Name Box with an exact range, such as A2:A100, when you need a dependable boundary.

Does Ctrl+Spacebar select the whole column in an Excel table?
Not necessarily on the first press. In a table, Excel can select the table’s data cells first and expand the selection with additional presses. Check the highlighted area to distinguish the table field from the full worksheet column.

What is the Mac shortcut for selecting a column in Excel?
Use Control+Spacebar in Excel for Mac. If macOS uses that combination for an input-source action, click the column heading instead or adjust the system shortcut conflict.

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.