Best Microsoft Excel Bloggers

Monday, May 18, 2015

Deleting Blank Sheet Rows

Deleting Blank Sheet Rows


When you import or download data, you frequently end up with a lot of blank rows that are interspersed among the data. You could sort and then delete all the blank rows or you could filter all the non-blanks but, in addition to being time-consuming, sometimes it does not display the data the way you want.
If you select the column that you are interested in and then click on Find & Select and then select  Go To Special .. and  then select Blanks -  you will find that this is a more efficient way. Then select the dropdown arrow beside Delete on the Cell tab and select Delete Sheet Rows.  To see an example of how this works please click here.

Ms. Excel- Resident Excel Geek