Remove Blank Rows in an Excel Spreadsheet

This is a method for removing blank rows from an Excel worksheet. I’ve tested it up to version 2007.

  1. Select a column containing blank rows by clicking on letter at top
  2. Hit F5 to bring up the ‘Go To’ box
  3. Select ‘Special…’
  4. Select the ‘Blanks’ button, then ‘OK’ – this will select all blank rows in the column.
  5. Right-Clink into any of the blank cells and chose ‘Delete’
  6. In the Delete box that pops-up chose ‘Entire Row’ then ‘OK’

All blank rows should now be gone!


This entry was posted in MS Office Tips. Bookmark the permalink. Follow any comments here with the RSS feed for this post. Both comments and trackbacks are currently closed.