1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

Delete Columns in Excel

Quickly Delete Columns using the Mouse in Excel

By

Delete Excel Worksheet Columns

Delete Excel Worksheet Columns

© Ted French

As with all things Microsoft, there is more than one way to delete columns from an Excel worksheet. These instructions show you how to delete columns by right clicking on the column header.

The column header is the gray bar along the top edge of the worksheet containing the column letters.

Delete Columns in an Excel Worksheet

Note: if you delete rows containing data, the data is deleted as well. If you make a mistake use the Undo feature on the ribbon or this keyboard shortcut to get your data back.

To delete more than one column from a worksheet, select more than one column in the column header. For example, if you want to delete two columns, select two columns in the column header.

To delete a single column

  1. Right click on the column header of the column you want to delete.
  2. Choose Delete from the menu.
  3. The column will be deleted.

To delete multiple columns

  1. In the column header, select the number of columns you want to delete from the worksheet.
  2. Right click on the selected columns.
  3. Choose Delete from the menu.
  4. The columns will be deleted.

©2014 About.com. All rights reserved.