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 under the Edit menu 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
- Right click on the column header of the column you want to delete.
- Choose Delete from the menu.
- The column will be deleted.
To delete multiple columns
- In the column header, select the number of columns you want to delete from the worksheet.
- Right click on the selected columns.
- Choose Delete from the menu.
- The columns will be deleted.
