How to Remove All the Blank Rows in Excel 2007

Written by emmanuelle douglas
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Remove All the Blank Rows in Excel 2007
Remove blank rows in your spreadsheet by using filters. (keyboard image by red 2000 from

Excel 2007 has several features to help you enhance your workbooks. These features can remove unnecessary data and spaces from your final spreadsheet. Removing blank rows can be done by applying a filter to your data. When the filter is applied, drop-down icons appear in the column headers of your data. Once this is done, you can customise the filter to display rows that have data. The blank rows will be hidden by using this feature.

Skill level:


  1. 1

    Open Excel 2007 and select a workbook. Select the "Office" button and click "Open." Search your network for the workbook. Click the workbook and select "Open." The workbook opens.

  2. 2

    Select the first column header in your workbook. Select the "Home" tab and click "Filter" from the "Sort & Filter" button in the "Editing" group. Notice the drop-down icons that appear in your column headers.

  3. 3

    Select a column header that may contain blank data. Click the drop-down icon. Scroll down in the list and locate "Blanks." Remove the check. The blank rows from this column are removed.

  4. 4

    Repeat this step for each column that may contain blank data. Once you have done this for each affected column, all of the blank rows will be removed from your Excel 2007 workbook.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.