via https://youtu.be/_sLbzkN4veg

In this video, I show you how to delete a pattern of rows in Excel. This was a request in the Microsoft Tech Community (https://techcommunity.microsoft.com/) asking how to automate deleting 3 rows after every 2 rows.

This was my solution as demonstrated in my video above:

  • Add a column to designate which rows to keep or delete
  • Enter “keep” or “delete” in the pattern you want down the column next to the rows you want to keep or delete (i.e. keep 2, delete 3 = keep, keep, delete, delete, delete)
  • Highlight the pattern and drag it down the list to populate every 2 rows with keep followed by 3 rows with delete
  • Sort or filter by keep/delete to remove unwanted rows. You can go to Data – filter to filter to just show the rows marked as keep OR you can sort by the keep/delete column and just delete every row marked as delete.