How to Delete Multiple Columns in Excel with a Condition – 3 Methods

This is the sample dataset.

To delete multiple columns based on a condition (for example, with a negative Rh factor):

Method 1 – Use the Find & Replace Tool to Delete Multiple Columns with a Condition

Steps:

• Select the row with the condition. Here, Rh Factor.

• Press Ctrl+F to open up the Find and Replace dialog box.

• In Find what, enter Negative and click Find All.

• You will see the list of cells that contain this word.
• Press Ctrl+A to select those cells and close the window.

• All cells that meet the condition are selected and highlighted.
• Hold Ctrl and press the – to open the Delete dialog box.

• Select the Entire column and click OK to delete the columns that contain those cells.

Read More: How to Delete Every Other Column in Excel

Method 2 – Deleting Multiple Columns with Blank Cells

To delete columns with blank cells, use the Go to Special feature:

Steps:

• Select the dataset and click F5 to open the Go to dialog box.
• Click Special.

• In the Go to Special window, select Blanks and click OK.

• You will see that blank cells are highlighted.

• Press Ctrl and –  to open the Delete dialog box.
• Select Entire column to see the final result.

Method 3 – Utilize the Sort & Filter Feature to Delete Multiple Columns Based on a Condition

Sort data, group cells with the condition, and then manually delete them.

Steps:

• Insert a helper row to store the serial number of the cells.

• Select the dataset (exclude the headers).

• Go to the Data tab and select Sort in Sort & Filter.

• In the Sort window, click Options.

• Choose Sort left to right and click OK.

• In Sort by, select the row number based on which data will be sorted. Here, row 7 (the Rh factor).
• Click OK.

• The negative Rh factor cells are sorted. Select those cells and delete the Entire column as described in the previous methods.

• This is the output.

How to Delete Rows Based on Conditions

This is the dataset:

The employees are divided in 3 groups (A, B & C). To delete the rows that contain group C, use the Filter option:

Steps:

• Select the entire dataset and select Filter in the Data tab.

• The header column displays a filter icon.
• Click the filter icon in Group and select Sort A to Z.
• Click OK.

• The list is sorted: rows containing group C are at the bottom.

• Select those three cells and press Ctrl and – to open the Delete dialog box.

• Select the Entire row and click OK. The 3 rows will be deleted.

Download Practice Workbook

Related Articles

• How to Delete Blank Columns in Excel
• How to Delete Column in Excel Without Affecting Formula
• How to Delete Multiple Columns in Excel
• How to Delete Column in Excel Without Affecting Formula
• How to Delete Unused Columns in Excel
• How to Delete Unused Columns in Excel
• How to Delete Infinite Columns in Excel
• How to Delete Hidden Columns in Excel
• How to Delete Columns with Specific Text in Excel
• [Solved!] Can’t Delete Extra Columns in Excel

<< Go Back to Delete Columns | Learn Excel