Excel Column Shortcuts for Selecting, Inserting and Hiding

How-to basics · Updated November 18, 2026

In Excel for Microsoft 365 on Windows, press Ctrl+Space to select a column, Ctrl+Shift++ to insert a column, Ctrl+- to delete a selected column, and Ctrl+0 to hide it. These shortcuts work best when you first select the column by clicking its lettered header; ribbon commands and the Name Box are dependable alternatives when a shortcut is unavailable or behaves differently.

What Excel column shortcuts do

A column shortcut can select a whole vertical range, change the worksheet structure, or alter how much information is visible. The same key combination can have a different effect depending on whether a cell, a range of cells, or a column header is selected. Before using a command that deletes or inserts anything, check the selection outline and the column letters at the top of the sheet.

For a quick reference on Windows:

  • Select the current column: Ctrl+Space.
  • Insert a column: select its header, then press Ctrl+Shift++.
  • Delete a column: select its header, then press Ctrl+-.
  • Hide a column: select its header, then press Ctrl+0.
  • Unhide columns: select the surrounding columns and use Ctrl+Shift+0, if that shortcut is available on your Windows setup.

These are worksheet commands, not Excel formulas. A shortcut does not permanently change a column’s contents unless you use an edit such as deletion; hiding merely changes what is displayed.

Select one or more columns

Clicking a column letter, such as D, selects all of column D, including cells that are currently blank. Ctrl+Space does the same for the column containing the active cell. For example, click a cell in column F and press Ctrl+Space to select the full column; you can then apply formatting, hide it, or use a column-level command.

To select adjacent columns, select the first header, hold Shift, and select the last header. Selecting headers C through E includes all three columns. To select separate columns on Windows, hold Ctrl while clicking their headers. On a Mac, Command-click is generally used for separate selections; some selection behavior can depend on the Excel version and input device.

When a cell inside an Excel table is active, Ctrl+Space can select the table’s data column rather than behaving exactly like a selection in an ordinary worksheet range. Pressing it again can expand the selection. Check which cells are highlighted before applying a formatting or data operation, especially if the table has a total row or you intend to affect the entire worksheet column.

Insert and delete columns safely

To insert a whole column in the middle of a sheet, select the header where the new column should appear, then press Ctrl+Shift++ on Windows. On a standard keyboard, the plus sign is usually typed with Shift and the equals key. Excel inserts the new column to the left of the selected one and shifts existing columns right. If you select columns D and E before inserting, Excel inserts two columns to their left.

If you have selected a cell rather than a whole column, the insert shortcut opens an Insert dialog so you can choose what to shift. To avoid inserting cells when you meant to insert an entire column, select the column header first. You can also use Home > Insert > Insert Sheet Columns.

To remove a full column, select its header and press Ctrl+- on Windows. Excel deletes the selected worksheet column and shifts the columns to its right leftward. If only a cell or cell range is selected, the Delete dialog offers choices such as shifting cells; it does not necessarily delete the entire column. The ribbon alternative is Home > Delete > Delete Sheet Columns.

Deleting and hiding are not interchangeable. Deletion removes the column and its contents from the sheet, while hiding leaves the data in place and can be reversed. If you are unsure whether the information may be needed later, hide the column or save a copy before deleting it. Excel’s Undo command can reverse many recent edits, but it is not a substitute for checking a structural change before continuing with other work.

Hide and unhide columns

With one or more column headers selected, Ctrl+0 hides those columns on Windows. The columns remain part of the workbook: formulas can still refer to their cells, and unhiding them restores their display. A hidden column is therefore useful for temporarily moving helper data or less relevant fields out of view, not for protecting confidential information.

To unhide columns with the mouse, select the headers on both sides of the hidden area, right-click the selection, and choose Unhide. For example, if D is hidden, select C and E, right-click, and choose Unhide. If the hidden column is at the far left or right of the sheet, use the worksheet’s Select All corner and then choose Home > Format > Hide & Unhide > Unhide Columns.

Ctrl+Shift+0 is the Windows shortcut commonly associated with unhiding columns, but it may be intercepted or disabled by Windows language or keyboard settings. If it does nothing, use the ribbon path instead. Also check for a very narrow column: a column that looks missing may have been reduced to almost zero width rather than hidden. Selecting its neighbors and choosing Unhide or setting a width can help distinguish the cases.

Change column width and fit contents

Column width is often the reason someone searches for a column shortcut. In Windows Excel, the ribbon key-tip sequence Alt, H, O, W opens the Column Width command; type a value and press Enter. Alt, H, O, I runs AutoFit Column Width for the selected column or columns. These are sequential key presses, not keys to hold down simultaneously.

The mouse method is often easier to remember. Drag the boundary between two column headers to adjust width. Double-click that boundary to AutoFit the column to its contents. To apply one width to several columns, select their headers first and then drag a boundary or use Home > Format > Column Width. AutoFit considers displayed cell contents, including text and numbers; a long entry can make a column much wider than expected.

Width is a display setting rather than a change to the underlying value. A date that appears as number signs, for example, may simply need a wider column, although the cell’s number format can also affect what is shown. If AutoFit produces an unwieldy width because of a long note, wrap the text or set a practical width rather than letting that one cell dictate the layout.

Move around columns without the mouse

To jump across a block of populated cells, press Ctrl+Right Arrow or Ctrl+Left Arrow from a cell in that region. Excel moves to the edge of the current data region, with blank cells and gaps affecting where the jump stops. Ctrl+Shift+Right Arrow or Ctrl+Shift+Left Arrow extends the selection as it moves. These commands navigate cells; they do not select a whole column by themselves.

The Name Box, to the left of the formula bar, is useful for direct navigation and selecting columns. Click it, type D:D, and press Enter to select all of column D. Type C:F to select columns C through F. This can be quicker than scrolling across a wide sheet and is a useful fallback if Ctrl+Space is inconvenient. You can also type a cell reference such as M250 to go directly to that cell.

For a large workbook, combine navigation with a deliberate action: enter a target column in the Name Box, confirm the selection, and then use the ribbon command you need. This reduces the risk of applying a deletion or format to the wrong area simply because the active cell was farther down the sheet than expected.

Mac and Excel for the web differences

In Excel for Mac, Control+Space is the usual shortcut to select the column containing the active cell, but macOS may use that key combination for an input-source feature. If it is intercepted, select the lettered header or use the Name Box. Mac keyboards and Excel releases can differ in the way they handle insert, delete, hide, and unhide shortcuts, so use the Home tab’s Insert, Delete, and Format commands when a Windows shortcut does not translate directly.

Excel for the web also supports many familiar shortcuts, but browser shortcuts can conflict with Excel commands, and the exact set can vary by browser and keyboard. Use the column headers and ribbon when a shortcut is caught by the browser or the operating system. For work that depends on a particular shortcut, check Excel’s in-product shortcut help for the version and platform you are using rather than assuming every Windows key sequence works unchanged on a Mac or in a browser.

When using a Mac, check system keyboard settings if Control+Space does not reach Excel. For all platforms, the mouse and ribbon remain valid options; a keyboard shortcut is a faster route, not a requirement for changing a worksheet.

Common problems and how to avoid them

  • The shortcut affects cells instead of a whole column: select the column letter first, then retry the command. A cell selection can open an insert or delete dialog instead.
  • Ctrl+0 appears to do nothing: confirm that a column header is selected and that you are in desktop Excel for Windows. Use Home > Format > Hide & Unhide if the operating system intercepts the key.
  • A column seems missing: inspect the header sequence for a skipped letter. The column may be hidden or extremely narrow; select the surrounding headers and try Unhide, or adjust the boundary.
  • Inserted data shifted unexpectedly: Excel inserts a column to the left of the selected header. Undo immediately if that was not intended, and verify the target header before repeating the command.
  • Only part of a table is selected: table selection shortcuts can target table data rather than an entire worksheet column. Look at the highlighted range before formatting or deleting.

A useful habit is to distinguish selecting a column from selecting its contents. Clicking the header is the clearest way to signal a whole-column operation. This is especially important before deleting, because a command applied to a cell range may offer different choices from one applied to an entire column.

Frequently Asked Questions

What is the shortcut to select a column in Excel?
On Windows, select a cell in the column and press Ctrl+Space. Clicking the column letter also selects the full worksheet column. On Mac, Control+Space is commonly used, but macOS settings may intercept it.

How do I insert a column using the keyboard?
On Windows, select the column header where the new column should go and press Ctrl+Shift++. Excel inserts a column to its left. If a cell rather than a full column is selected, Excel may show the Insert dialog.

How do I unhide a column in Excel?
Select the headers on either side of the hidden column, right-click, and choose Unhide. You can also use Home > Format > Hide & Unhide > Unhide Columns. The Ctrl+Shift+0 shortcut may be unavailable because of Windows settings.

Does hiding a column delete its data?
No. Hiding only removes the column from view; formulas and other references can still use its contents. Use Delete Sheet Columns to remove the column itself, and avoid hiding data as a way to secure sensitive information.

How can I make Excel columns fit their contents?
Select the columns and double-click the boundary between two selected column headers to AutoFit. In Windows Excel, the key-tip sequence Alt, H, O, I also runs AutoFit Column Width.

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.