Excel Hack

Shortcut to delete column in Excel

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

Select a cell in the column you want to delete.

Select an entire column

Select an entire column

Press Ctrl + Space to select the entire column.

Delete selected 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 the cells in the column you want to delete

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

Select Entire column

Delete dialog box will appear.

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

Deleting a column

The columns of the selected cells have been deleted.

Use shortcuts to delete multiple columns

Select a cell

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

Select multiple cells

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

Select multiple columns

Ctrl + Space to make multiple columns selected.

Delete multiple columns

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

Comments

Please send us your comments on this article.

0 comments
Inline Feedbacks
View all comments