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!


Posted in MS Office Tips | Comments Off