Shortcut to delete column in Excel

• Release Jan 24, 2022Update Aug 24, 2022
• Written in Excel for Microsoft 365 version 2202

Excel has a shortcut key for deleting columns: you can select one or more columns and use the shortcut key to delete the columns. You can also select a cell to bring up a dialog box to delete a column. If you have been using the mouse to delete columns, learning the shortcut keys will dramatically improve your work efficiency.

Delete column shortcut

Windows
Ctrl + – (minus)
Access Key: Alt + H + D + C

Mac
command + – (minus) or control + – (minus)

Delete a column using a shortcut

This section describes how to delete a column using the shortcut keys.

Total Time: 1 minute

Select a cell

Select a cell in the column you want to delete.

Select an entire column

Press Ctrl + Space to select the entire column.

Delete selected column

Press Ctrl + - (minus) or Alt + H + D + C to delete the selected column.

Display a dialog box to delete a column

Select one cell in the column you want to delete. Press Ctrl + – (minus) or Alt + H + D + C.

Delete dialog box will appear.

Use the ↓ (Down Arrow key) to select the Entire column, and press Enter.

The columns of the selected cells have been deleted.

Use shortcuts to delete multiple columns

Select any one cell in the column you want to delete.

Press Shift + → (Right Arrow key) to select multiple columns.

Ctrl + Space to make multiple columns selected.

Press Ctrl + – (minus) or Alt + H + D + C to delete multiple selected columns.