Forum Discussion
Excel
Dec 04, 2020Iron Contributor
delete 3 rows after every 2 rows
Hello Everyone, I have a data and trying to delete 3 rows after every 2 rows. How can I do it as deleting them? Because manually takes too long. Like -
sally365
Dec 04, 2020Brass Contributor
Hey Excel,
I think I found a solution for you, as long as the pattern remains keep 2, delete 3.
- 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.
Highlight the pattern and drag it down the list to populate every 2 rows with keep followed by 3 rows with delete:
I also created a video for this if that makes it easier to understand: https://youtu.be/_sLbzkN4veg
I hope this resolved your question!