Excel 2007: Eliminate Blank Rows in a Spreadsheet

Contributor Icon Contributed by shamanstears Date Icon March 8, 2007  
Tag Icon Tagged: Microsoft Excel

Blank rows can be beneficial when it comes to making your spreadsheet easier to read, however if you are going to pull the data into another application (such as Access), the blank rows can cause you some problems. You could go through the painful task of selecting and removing these rows individually, but if you are working with a large spreadsheet, it could take forever to accomplish this. Instead, utilize Go To Special and let Excel do the work for you. Here’s how:


1. Select the range of data that contains the blank rows.

2. Go to the Ribbon, and select the Home tab.

3. In the Editing section, click the small arrow next to Find & Select.

4. Select Go To Special.

5. Select the Blanks radio button and click OK.

6. All blank rows within the selected data range will be highlighted.

7. Go to the Ribbon.

8. Click the small arrow beneath Delete.

9. Select Delete Sheet Rows

Previous recipe | Next recipe |
 
  • Lee
    incorrent... it selects all empty _cells_, not rows, and then deletes any row that has at least one empty cell
  • I used Data > Remove duplicates" It leaves you with only 1 blank row. This of course assumes you have no other duplicates.
  • Bob
    Thanks mate.... cheers!
  • Bob
    Sorry... agree with Lee, all rows with blanks are deleted and this is not what I want
  • Bob
    Agree with Lee, can try sorting data on spreadsheet then all blank rows will be together where they can be deleted
  • Ann
    Thank you
  • meka
    Yes, this won't work if you select the entire spreadsheet. Try only selecting one column that you know has data in every column you need saved. Then follow the steps above to delete the empty rows.
blog comments powered by Disqus