Excel Guides

Getting Rid of Empty Rows after Importing in Excel

If you're working with data in Excel, you may find that you have a lot of empty rows. Maybe you imported the data from another program, or maybe you just have a lot of blank cells. Either way, getting rid of those empty rows can be a pain. Here's a quick and easy way to do it.

  1. First, select the data that you want to remove the empty rows from. You can do this by clicking on the top-left cell in your data range, and then dragging your mouse down to the bottom-right cell. The entire range should be highlighted.
  2. Next, go to the Data tab on the ribbon, and click Filter. This will add little drop-down arrows to each column header.
  3. Click on the drop-down arrow for the first column header, and uncheck the (Select All) box at the top. Then, scroll down and check only the boxes for the non-empty cells. For example, if your first column contains dates, check only the boxes for cells that have dates in them.
  4. Repeat step 3 for each column header.
  5. Now all of your empty rows should be hidden. To delete them, simply press Ctrl+-. (That's the minus sign on your keyboard.)
  6. You should now see a dialog box asking if you want to delete entire rows. Click OK, and all of your empty rows will be deleted!

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.