In Excel for Microsoft 365 on Windows, select any cell in the column and press Ctrl+Space to select the entire worksheet column. The selection includes blank cells as well as those containing data; on a Mac, the equivalent shortcut is usually Control+Space.
How the Windows shortcut works
Click a cell in the column you want, then press Ctrl+Space. For example, if the active cell is D12, the shortcut selects all of column D, from its header through the final row in the worksheet. Excel highlights the column, while the active cell generally remains the white cell within that highlighted area.
The shortcut selects a column; it does not move, erase, or change the values in it. It is useful when you want to apply formatting to a whole field, inspect a column, copy it, or prepare to insert or delete a worksheet column. What happens next depends on the command you choose, so selecting a column is not the same thing as deleting it.
- Click a cell in the desired column, such as C5.
- Press Ctrl+Space on a Windows keyboard.
- Check the highlighted column before applying a formatting or editing command.
If you are typing or editing inside a cell, first press Enter or Esc to finish or cancel the edit. While Excel is in cell-edit mode, a spacebar press can enter a space in the cell rather than select a column.
What selecting a whole column includes
A worksheet column is larger than its visible data. In current Excel worksheets, each column contains 1,048,576 rows. Ctrl+Space selects that full worksheet column, including empty cells below a short list. If column B has a heading in B1 and values through B40, the selection still extends down the rest of B.
This distinction matters when you apply a format or use a command that acts on every selected cell. For instance, setting a number format on a whole column can make future entries in that column display consistently. But a whole-column selection can also make some calculations or workbook operations less efficient than selecting only the used range, particularly in formulas that process large ranges. Choose the full column when you genuinely want the entire field, not just because it is easier to highlight.
Only the selected column or columns are targeted by many commands. If you select a whole column and press Delete, Excel clears cell contents; it does not remove the worksheet column itself. Deleting the actual column is a separate operation and shifts the columns to its right.
Selecting more than one column
You can use the shortcut with a range of cells to select the worksheet columns that contain that range. For a single continuous block, selecting cells from C3 through E8 and pressing Ctrl+Space selects columns C, D, and E. This is handy for applying the same width, number format, or other column-level change to adjacent fields.
For columns that are not next to one another, use the column headers instead. Click the letter above the first column, then hold Ctrl while clicking other column letters on Windows to add them to the selection. Take care not to click a cell in the grid when you intend to add a header: that can replace the existing selection rather than extend it. If a command should affect every column between two endpoints, select the first header, hold Shift, and click the last header.
When multiple cells or a complex range are selected, the exact selection you intend may not be obvious. Look at the highlighted column letters and the shaded cells before changing data or formatting. If the result is not right, click a single cell in the target column and repeat the shortcut.
Excel tables behave differently
An Excel table is a formatted, structured data range with its own header row and table features. If the active cell is inside a table, Ctrl+Space can select the table column rather than immediately highlighting every cell in the corresponding worksheet column. Repeating the shortcut can expand the selection to include more of the table or the worksheet column, depending on the table context and what is already selected.
This behavior is useful when you want to format or work with one table field without affecting the rest of a very large worksheet column. For example, selecting a cell under the Sales heading and using Ctrl+Space can target that table field. If you specifically need the entire worksheet column, check whether the highlight reaches the worksheet column boundaries; otherwise, click the column letter at the top of the sheet. That header click is the clearest way to select the entire worksheet column when a table is involved.
Table headers also offer a way to select a table field directly: click the table’s header cell or use its selection controls. Be aware that a table’s header is not the same as the worksheet’s column-letter header. The worksheet header is the letter such as D; the table header is the label such as Sales.
Other ways to select a column
The keyboard shortcut is quick, but there are reliable alternatives for touchpads, unfamiliar keyboards, or situations where Excel or the operating system intercepts a key combination.
- Click the column letter: Click A, B, C, or another letter at the top of the worksheet. This selects the full worksheet column directly.
- Use the Name Box: Click the Name Box to the left of the formula bar, type A:A, and press Enter to select column A. Replace A with the required column letter. Type A:C to select columns A through C.
- Use Go To: Press Ctrl+G, enter a reference such as D:D, and press Enter. Excel selects the specified column. The reference can also cover multiple adjacent columns, such as D:F.
These methods can be especially helpful when the desired column is far from the currently visible area. Typing a column reference avoids scrolling across a wide worksheet, and clicking a header avoids ambiguity about whether a table field or a worksheet column is selected.
Windows, Mac, and Excel for the web
For desktop Excel on Windows, Ctrl+Space is the standard shortcut. In Excel for Mac, use Control+Space. Mac keyboards and macOS settings can make this combination unavailable to Excel: macOS may assign Control+Space to switching input sources. If the shortcut changes the input language or does nothing in Excel, use the column-letter header or Name Box, or review the relevant keyboard shortcut under macOS system settings.
Excel for the web runs inside a browser, so browser and operating-system shortcuts can sometimes affect which keystrokes reach the worksheet. Try Ctrl+Space, but if the browser responds or Excel does not select the expected column, click the worksheet column letter. The visual header method works without relying on a keyboard shortcut.
Shortcut behavior can also vary with keyboard layout, remote desktop software, and accessibility tools. When sharing instructions with someone using a different device, name the action as well as the keys: select a cell in the column, then use Ctrl+Space on Windows or Control+Space on Mac, with clicking the column letter as the fallback.
Common problems and safe next steps
If Ctrl+Space seems to insert a blank space or has no effect, the most common cause is that Excel is editing a cell rather than waiting for a worksheet command. Press Enter to commit the edit or Esc to cancel it, click a cell, and try again. If you are working inside a table, confirm whether Excel selected the table field instead of the full worksheet column.
Another common misunderstanding is confusing Clear Contents with Delete Columns. With a full column selected, pressing the Delete key clears the contents of selected cells but leaves the column in place. To remove the worksheet column, right-click its letter and choose Delete, or use the appropriate delete command on the ribbon. Removing a column shifts other worksheet content, so check for formulas, charts, and references that may depend on it before proceeding.
Before using a selection for a destructive operation, verify the highlighted column letters. If the wrong column is selected, click the correct header or press Esc and start again. A selection itself is reversible: it does not alter the workbook until you perform an action such as typing, applying formatting, clearing cells, or deleting a column.
Related shortcuts and useful distinctions
Several nearby Excel actions are easy to mix up. On Windows, Shift+Space selects the worksheet row containing the active cell. Ctrl+Space selects a column. Clicking a row number or column letter provides the same basic selection without a keyboard shortcut.
Ctrl+A is not a substitute for selecting one column. In a data region, it can select the current region, and using it again can expand the selection; the exact result depends on where the active cell is. For a single full column, Ctrl+Space or clicking the column letter is more direct. Similarly, selecting a column does not automatically select the whole worksheet: it selects one column, or the columns represented by the current selection.
Selection also does not mean every later action fills every cell. Typing a value with a whole column selected normally changes the active cell, not all million-plus cells in the column. If you intend to enter the same value into a selected range, Excel has separate ways to fill selected cells; make sure you understand the effect before using them on a whole column.
Frequently Asked Questions
What is the shortcut to select an entire column in Excel?
On Windows, click a cell in the column and press Ctrl+Space. On Mac, the usual equivalent is Control+Space. Clicking the letter at the top of the column is a dependable alternative on either platform.
How do I select a whole column without a mouse?
On Windows, move the active cell into the desired column with the keyboard, then press Ctrl+Space. You can also use Ctrl+G, type a reference such as B:B, and press Enter. On a Mac, try Control+Space, subject to macOS shortcut settings.
Why does Ctrl+Space not select the whole column?
You may be editing a cell, using a Mac where macOS has claimed Control+Space, or working inside an Excel table where the shortcut selects a table field first. Finish the cell edit, check the selected area, or click the worksheet column letter.
Does selecting a column delete its data?
No. Selecting a column only highlights it. Pressing Delete clears selected cell contents, while deleting the worksheet column is a separate command that removes the column and shifts other content.
How do I select several columns at once?
Select a cell range spanning the columns and press Ctrl+Space on Windows, or select the column letters directly. For a continuous group, click the first letter, hold Shift, and click the last. Use Ctrl-click on Windows to add separate column headers.
Related
- Excel Print: Keep Row and Column Headers on Every Page
- Excel Print Header on Each Page: Repeat Rows in Print
- Excel Print Top Row on Every Page
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Turn Off Circular Reference Warning?Excel has no separate setting that simply hides circular-reference warnings while continuing to flag circular formulas. To stop…
- Google Docs Employee Schedule Template: Create and Share ItYes. You can make a Google Docs employee schedule template by inserting a table, adding dates and shift…
- Create QR Codes in Word Mail MergeTo create a QR code for each recipient in a Word mail merge, insert a DISPLAYBARCODE field that…
- Google Sheets Percentage Calculator: Formulas and ExamplesTo use Google Sheets as a percentage calculator, enter the part and the total in cells, then divide…
- How to Clear the AutoComplete Cache in OutlookTo clear every saved recipient suggestion in classic Outlook for Windows, select File > Options > Mail >…
- Excel Named Range Scope: Workbook vs. Worksheet NamesIn Excel, a named range’s scope determines where its name can be used: a workbook-scoped name is available…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.