In this guide, we're going to show you how to remove all rows containing specific value in Excel. We are going to be taking a look at two methods:

  • Find and Replace
  • Filter

These methods are good for removing all rows containing a specific value, such as repeating headers.

Removing all rows containing specific value using Find and Replace

  1. If you wish to perform removing a specific range, select your data, including the values you want to remove. Otherwise, you do not need to select any cells.
  2. Press the Ctrl + F key combination to open Find and Replace.
  3. Type in the value in the rows you want to remove.
  4. Click Find All.
  5. Select any of the found values in the results pane.
  6. Press Ctrl + A to select all of them. You can select specific values you want to remove by using Ctrl or Shift keys.
  7. Close the Find and Replace window.
    How to remove all rows containing specific value in Excel - Find Replace
  8. Press Ctrl + - to open Delete
  9. Select Entire row
  10. Click OK button to delete those rows.

After clicking OK, Excel will remove all rows containing the selected cells.

Warning: If found and selected items contain an Excel Table header, the Ctrl + - shortcut will not work.

Removing all rows containing specific value using Filter

This approach is more suitable for data in a table structure.

  1. Select your data, including the values you want to remove.
  2. Press Ctrl + Shift + L to enable Filters. Alternatively, you can click Filter in Data tab.
  3. Click the down arrow in the header of the column that contains the value you want to select.
  4. Select the value(s) you want to remove in the filter dialog.
  5. Click OK to apply the filter.
    How to remove all rows containing specific value in Excel - Filter
  6. Select each cell individually by clicking cells while holding down the Ctrl key. Don’t use the Shift key or drag the mouse to select cells.
  7. Once the cells are selected, press Ctrl + -.
  8. Click OK on prompt dialog to delete rows.

Clear the filters to see the remaining rows.