![]() Add some random numbers to each cell in the range B2:B7. Next, input ‘Jan’ in A2, ‘Feb’ in A3, ‘Mar’ in A4, ‘April’ in A5, ‘May’ in A6 and ‘June’ in cell A7. ![]() Enter ‘Column 1’ and ‘Column 2’ in cells A1 and B1. However, if your table is small enough, it might be the fastest approach.įor an example, let’s set up a table in a blank Excel spreadsheet. 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |