Delete Blank Rows in Excel
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.
Step 1
Step 2
Step 3
Step 4
Final Product
– Mark Flavin
Thanks for the help, Loren. I am excel challenged, my friends laugh at me.
No problem Missy, there are a lot of features to excel and it is not easy to know them all, I promise not to laugh at you. If you have any questions about how to do something in Excel just leave a comment and I will write on it.
Hi Mark,
I liked the Excel Help information on this blog.
1) Very well explained.
2a) You gave an Easy solution that I didnt think of using the Data/Sort command.
2a) Then you gave a more Excel-centric solution that leveraged some of Excels less well known menu commands.
3) And the explanations and “how tos” and “screenshots” were well written & easy to understand.
4) By far this is 1 of the best Excel Help blogs I have used.
Thanks,
–Andrew , CA —