Written by Allen Wyatt (last updated April 27, 2020)
This tip applies to Excel 97, 2000, 2002, and 2003
When working with data retrieved from another source—such as another user or from an external program—you may have a need to remove certain rows from the data. It is not unusual, for instance, to have the need to remove every third row or every fifth row. The following general steps allow you to delete every X rows without using a macro.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2348) applies to Microsoft Excel 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: Deleting Every X Rows without a Macro.
Program Successfully in Excel! This guide will provide you with all the information you need to automate any task in Excel and save time and effort. Learn how to extend Excel's functionality with VBA to create solutions not possible with the standard features. Includes latest information for Excel 2024 and Microsoft 365. Check out Mastering Excel VBA Programming today!
Too much data in your worksheet? Does too much of that data duplicate other data? Here's how to get rid of the duplicates ...
Discover MoreYou can delete cells from a worksheet, and Excel will move the remaining cells either to the left or upwards. Deletions, ...
Discover MoreImport data from another program, and you could end up with a lot of blank columns in your data. Here's the quickest way ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2020-04-27 13:17:21
Daniel Fruge
Thank you, Mr. Wyatt, for the tip. To substitute step 2 above, you could use this updated formula =MOD(ROW(A1),3).
Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2025 Sharon Parq Associates, Inc.
Comments