How to Delete Columns in Excel Shortcut

Excel is a powerful tool that is widely used for organizing, analyzing, and presenting data. When working with large sets of data, it is often necessary to delete columns that are not relevant or needed. This article will provide you with a step-by-step guide on how to delete columns in Excel using shortcut keys.

Step 1: Select the Column

To delete a column in Excel, you must first select the column you wish to delete. You can do this by clicking on the column header, which is the letter at the top of the column. Alternatively, you can click and drag to select multiple columns.

Excel Column HeaderSource:

Step 2: Use the Shortcut Key

Once you have selected the column(s) you wish to delete, simply press the “Ctrl” and “-” keys simultaneously. This will bring up the “Delete” dialog box.

Excel Delete Dialog BoxSource:

Step 3: Choose “Entire Column”

In the “Delete” dialog box, make sure that “Entire Column” is selected. This will ensure that the entire column is deleted, including any data or formatting within the column.

Excel Delete Dialog Box With Entire Column SelectedSource:

Step 4: Click “OK”

Once you have selected “Entire Column,” click the “OK” button to delete the column(s). The column will be immediately removed from your Excel spreadsheet.

Additional Tips

Here are some additional tips to help you work more efficiently with Excel:

Use Shortcut Keys

Shortcut keys can save you time and make you more efficient when working with Excel. In addition to the “Ctrl” and “-” keys for deleting columns, there are many other shortcut keys that you can use to perform various actions within Excel.

Excel Shortcut KeysSource:


If you accidentally delete a column, you can use the “Undo” shortcut key (“Ctrl” + “Z”) to undo the action. This will restore the deleted column(s) to your Excel spreadsheet.

Hide Columns

If you do not want to delete a column, but simply want to hide it from view, you can use the “Hide” feature in Excel. To do this, right-click on the column header and select “Hide.” The column will be removed from view, but will still be present in your spreadsheet.

Excel Hide ColumnsSource:


Deleting columns in Excel using shortcut keys is a quick and easy process. By following the steps outlined in this article, you can work more efficiently with Excel and organize your data more effectively. Remember to use shortcut keys, undo accidental deletions, and hide columns when needed.

Related video ofHow to Delete Columns in Excel Shortcut

Kimbrain ID
Kimbrain ID

Seorang blogger enthusiasm & starter copy writer. Sangat tertarik dengan perkembangan dunia teknologi.