Comments on: How to delete every other row or every Nth row in Excel

There are many situations when you may need to delete every other row in your worksheets. This short tutorial will teach you a couple of quick ways to remove alternate rows or every Nth row in Excel. Continue reading →

Table of contents

Comments page 2. Total comments: 35

  1. Thank you
    It's very useful

  2. much help, 10/10.
    the mod command works great if you aren't used to vba!
    Thank you!

  3. Thank you so so much! You saved me so much time!

  4. you saved my lot of time and system space , thank you

  5. Thanks a lot. You really saved mytime.

  6. Thanks for the precious information..
    Will seek for other informations also.

  7. I love you so much for this!! You literally saved me hours.

  8. Very useful article, particularly 'How to delete alternate rows in Excel with VBA'.

    How do I add a form (and any additional code) that allows me to change the set 'alternate rows' to 'delete every Nth row or N Rows'. Other than going into the VBA editor For every new requirement.

    What I have in mind is say a button that on click calls a simple form that allows me to change the Nth Row or and N Rows parameters or confirm the last entered values. Press OK, Then Runs the dialog that prompt me to select a range.

    Thanks

    also 'How to delete alternate rows in Excel with VBA' might be better at the end of the Article so that all the 'filtering' non VBA subjects were together.

Post a comment



Thank you for your comment!
When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to
your query. We cannot guarantee that we will answer every question, but we'll do our best :)