Often when working with data especially data that is unformatted, such as the information I export from the MLS, I will receive a large number of blank rows interspersed with the information I am interested in. One solution would be to just sort the data and the blanks will be at the bottom or top of the list depending on the sort order. Now suppose the order of the data is as important as the data within the list well the technique below will allow you to delete the blank rows while preserving the order of the list.
Before you begin please make sure you save your workbook.
- Step one select the range of cells you want to remove blanks from
- Press F5 on your keyboard or click Edit and Goto
- Click the Special button
- Click the Blanks option and click OK.
- If you are using Excel 2007 choose click the arrow under delete on the ribbon and choose Delete Sheet Rows. If you are using Excel 2003 or Excel XP right click click delete and select entire row.
– Mark Flavin