Manually selecting and deleting the rows you don’t need might take quite a while if your table has hundreds or thousands of rows. Let’s get started! Delete Every Other Row Without Filters Then you can decide for yourself which technique is most suitable for your immediate need. In this article, I’ll show you how to use each one of these techniques. The second way is to use Excel’s Filter tool, and the third way is to use an Excel add-on. While cumbersome and possibly time-consuming, this might be the right approach if your table is very small.
The first way is to manually select and delete the rows you want to get rid of.
There are three basic ways of accomplishing this task.
