Tip: Quickly remove blank rows from a long list

Save 5 minutes a day by using ASAP Utilities to quickly remove all the empty rows in your dataset.

"Easily delete all empty rows that are in between"

One of the most common tasks in Excel is deleting blank rows. Whatever type of data you may have in Excel, there are many occasions where you will also have a bunch of blank rows throughout your worksheet.
If you have thousands of rows, manually deleting the empty rows is a time consuming and boring process.

Excel uses blank rows to determine data ranges. For example when sorting or filtering data.
Instead of looking manually for rows that are completely empty and delete them, just let ASAP Utilities do this for you.

You can removes all completely empty rows on your worksheet with:
ASAP Utilities » Columns & Rows » Delete all empty rows

A quick way to delete blank rows in Excel

Do you recognize any of these situations?

  • How can I remove all blank rows in an easy way without having to remove each blank row manually?
  • When I want to remove blank rows of data, I just select the data and press the sort AZ button. However, this shifts my data "out of order". Is there another method? I want to keep the data in its original order.
  • I have a huge excel file (3 sheets, all filled to the 65535 row limit).
    I need to remove all "blank" lines easily, but due to the nature of the data, I can't do a "sort" to bring all the blank lines to one location in the file. Is there an excel feature to do this, or a macro?

Just use the following tool:
ASAP Utilities » Columns & Rows » Delete all empty rows

Bonus tips, also interesting

  1. Columns & Rows » Delete all empty columns
  2. Columns & Rows » Delete all hidden rows and/or columns...
  3. Remove empty rows or columns within your selection only:
    Columns & Rows » Conditional row and column select, hide or delete...
  4. Columns & Rows » Delete unused empty ending rows/columns
  5. Columns & Rows » Detect and visualize adjacent data/group changes...
  6. Chip Pearson: Macro to delete blank rows

How much time will it save?

It's guaranteed that you'll save yourself time and effort by using this tool. However, the actual time saved depends on how much you use Excel, the amount of data you're working with and how often you use this particular tool.
You can easily see how much time ASAP Utilities has saved you so far.


In case you don't have ASAP Utilities yet, you can download the free Home&Student edition (for home projects, schoolwork and use by charitable organizations) or the fully functional 90-day Business trial.
Download page