# Excel help **URL:** \ **Category:** Factual Questions\ **Created:** [November 26, 2006, 6:32pm UTC](https://boards.straightdope.com/t/excel-help/381859 "2006-11-26T18:32:46Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![Queuing](https://avatars.discourse-cdn.com/v4/letter/q/90ced4/32.png) [@Queuing](https://boards.straightdope.com/u/Queuing)\ **Post date:** [November 26, 2006, 6:32pm UTC](https://boards.straightdope.com/t/excel-help/381859/1 "2006-11-26T18:32:46Z")
Hello, I am horrible with excel, yet I have to use it for year end inventory. In the excel data there are blank rows every so often, and when I import the data into another program these blank rows screw up the data. Is there a macro, or some quick way that I can delete all of this blank rows? Thanks. ---
**Author:** ![Trillionaire](https://avatars.discourse-cdn.com/v4/letter/t/aeb1de/32.png) [@Trillionaire](https://boards.straightdope.com/u/Trillionaire)\ **Post date:** [November 26, 2006, 6:47pm UTC](https://boards.straightdope.com/t/excel-help/381859/2 "2006-11-26T18:47:30Z")
Select the row at the top of your data. Then click the Data menu, then Filter, then Auto-Filter. Clicking on one of the filter arrows will give you an option to filter on “non-blanks”, which will get rid of the blank rows. You can then copy and paste special into a new worksheet and export from there. ---
**Author:** ![bannerrefugee](https://avatars.discourse-cdn.com/v4/letter/b/c68b51/32.png) [@bannerrefugee](https://boards.straightdope.com/u/bannerrefugee)\ **Post date:** [November 26, 2006, 6:48pm UTC](https://boards.straightdope.com/t/excel-help/381859/3 "2006-11-26T18:48:56Z")
[QUOTE=Queuing] Hello, I am horrible with excel, yet I have to use it for year end inventory. In the excel data there are blank rows every so often, and when I import the data into another program these blank rows screw up the data. Is there a macro, or some quick way that I can delete all of this blank rows? Thanks. [/QUOTE] Sort the data and delete the rows.