How to Delete every other Row in Excel

Have you ever needed to delete every other row in Excel? You are not alone.


There are a few ways to accomplish it. It’s a pretty good candidate for a VBA solution, but I’m going to show you how to quickly delete every other row without using VBA or a plugin. I won’t make you resort to all of your data either.

This method of Deleting every other row centers around two different Excel functions

  • Flash Fill to create an Index.
  • Filter to identify lines to delete

Here is our sample data set. Let’s begin removing every other row.

Step 1 – Create the Helper Cells

In a preceding column, Put a 1 in the first row and a 2 in the next row.

Right-click the bottom right corner of the cell and drag down.

When you reach the bottom, the dialog box will pop up with a bunch of options. Choose “Copy Cells.”

Great job! You just created an index or what my Excel friends like to call a “helper column.”

Step 2 – Filter on just the twos

Title the column “Index” or anything you want.

Then filter (Ctrl + Shift + L) on the index column to only display the twos. Now you only can see the rows you want to delete. Let’s get them out of here!

Step 3 – Delete the twos

Highlight all the visible rows (except the header!)

Shift + Space + Down Arrow. If you have a lot of rows, use Ctrl + Down Arrow. Then click Delete.

Step 4 – Unfilter

Every other row is now gone. I hope whats what you wanted! The undo command (Ctrl +Z) is there for you, just in case.

Latest Blog Posts

Learn about SQL joins using Excel

Learn about SQL joins using Excel

Why do we join tables in SQL? Tables that logically represent information are the foundation of relational databases. The ancient rules of database normalization remind us to arrange database tables to reduce redundancy and increase flexibility. An adequately...

Super Bowl Squares Template

Updated for Superbowl 57 This Version is unlocked, so be careful with the formulas. You have to press F9 to Regenerate the squares because calculations are set to manual. This spreadsheet is for educational purposes only. Please check your local gambling restrictions...

How to Return Multiple Matches in one Cell Using a lookup?

VLOOKUP is great for looking up a value and returning another corresponding value. But what happens when the first match just isn't enough. I've been tasked with finding a way to put return not just the first but the second, and third match. At first, I tried to...

Select the Email Service Provider that is right for you.

Select the Email Service Provider that is right for you. commits to continuous improvement. I've wondered if our Communication distribution process is lacking. Is there a more effective tool to help us share valuable content? Mailchimp has been's tool for email creation and...

Insert Multiple Rows into SQL table Using Excel as a Template

Insert Multiple Rows into SQL table Using Excel as a Template

I hope you followed the previous tutorial where we checked Created some brand new database tables using Excel as a template. Let's populate these tables with meaningful data. Okay, it might not be the most meaningful dataset since I just made this data up using...

Planning Software

Fiverr Freelancers

Share This