How To Delete Columns In Excel

Click Home Sort Filter Filter in Editing group.

How to delete columns in excel. Now choose the Delete Sheet Rows option under the Delete drop down box. Press and hold the Ctrl key. The easiest way to delete a column is to select the entire column to be deleted.

Deleting Columns in Microsoft Excel. Select the column that you want to delete from your Excel sheet. Another easy way to remove data in a worksheet is to delete entire columns or rows.

The blank columns are deleted and the remaining columns are contiguous just as the rows are. Press the Spacebar without releasing the Shift key. Click Delete in the Cells section of the Home tab and then select Delete Sheet Columns from the drop-down menu.

This shortcut will delete columns that are selected. And select Blank columns from Detailed type. Eliminate blank rows by Excel filter functionality.

How to Delete Blank Rows in Excel The Right Way. This process does not account for partially empty columns. The following steps show how to remove empty columns from an Excel spreadsheet using Excel 2016.

In the Go To Special dialog check Blanks option. Watch more How to Use Microsoft Excel videos. Click OK now all blank cells in the blank rows have been selected.