How to Delete Every Third Row in Excel (With Example)

Often you may want to delete every third row in Excel.

For example, suppose you have the following dataset that contains information about various basketball players:

The following step-by-step example shows how to delete every third row so that we’re only left with the following rows:

Let’s jump in!

Step 1: Enter the Data

First, let’s enter the following data into Excel:

Step 2: Create Helper Column

Next, type the word Delete into cell D4:

Then highlight the range D2:D4. Then click and drag down to all remaining cells in column D:

Each third row now contains the word Delete.

Step 3: Add Filter & Delete Rows

Next, highlight the range A1:D13, then click the Data tab along the top ribbon, then click the Filter icon within the Sort & Filter group:

Next, click the dropdown arrow next to the Helper column and then only check the box next to Delete, then click OK:

Once you click OK, only the rows with a value of Delete in the Helper column will be visible:

Next, highlight the four visible rows and then right click. Then click Delete Row from the dropdown menu:

Lastly, click the Filter icon again on the Data tab to remove the filter.

The only rows that will be left will be the ones that did not have a value of Delete in the Helper column:

We have effectively deleted every third row from the original dataset.

Note that you can also delete the Helper column if you’d like since we no longer need it.

Additional Resources

The following tutorials explain how to perform other common operations in Excel:

How to Delete Rows with Specific Text in Excel
How to Delete Filtered Rows in Excel
How to Delete a Table in Excel

Leave a Reply

Your email address will not be published. Required fields are marked *