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.
No comments:
Post a Comment