Hold down the Alt + F11 keys in Excel, and it opens the Microsoft Visual Basic for Applications window.Ģ. ![]() Click to download Kutools for Excel!Īctually, VBA macro is also a good choice to resolve this problem.ġ. Kutools for Excel's Select Interval Rows & Columns utility can help you to find and select every other or nth rows or columns, and then you can do some operations as you need. Select every other or nth row, column and then delete them at once At last, you can delete the helper column C as you need. Then it deletes every other row, and you need to click Filter button again to show only the rows with 1. Select the visible rows with 0, and click the Home > Delete > Delete sheet rows to delete these rows. Then click the arrow button beside C1, and only check the 0 under the Select All option. Select the column C, and click the Filter button under Data tab. In this case, we enter the numbers in helper Column C. In a blank column besides original data, enter 0,1,0,1…,0,1. Microsoft Excel's Filter command can help you quickly filter every other row and then delete them at once, please do as follows:ġ. And this article will show you some tricky things about how to select every other row or column first and then delete them quickly.ĭelete every other row in Excel with Filter commandĭelete every other row in Excel with VBA codeĭelete every other row or column in Excel with Kutools for Excel If you want to quickly delete every other row or column in Excel, the main point is how can you quickly select every other row or column first and then apply the delete operation to them. How to quickly delete every other row in Excel?
0 Comments
Leave a Reply. |