Did You Know ? You could Quickly Delete several Blank Rows in Excel

Guys if you have a huge worksheet with several blank rows, what do you do? The answer is simple.. Delete Them so that data is organized and can be used more meaningfully.

Question now is how do you delete all such blank row in single go? Do you write a macro? or Do you select each row manually and delete them? But what if the blank rows are in hundreds?

There is one simple and quick way to handling such spread sheets. Guess what? The best way to handle such scenario is to sort your data. Depending on your sort criteria the blank rows would either appear on top or at bottom. If they are at bottom you simply have no issues otherwise you could simply delete the blank rows.

But there could be an issue. What if you wanted all your data to be restored back in original order post deleting blank rows. There is a solutions to this. Below steps would be helpful…

1. Insert a column before the first column in data or use column next to the last column.
2. Enter numbers in the ascending order in first cell and drag it down till the last row containing data.
3. Sort the data on column other than the one you inserted in step 1.
4. Delete blank Rows in bulk
5. Sort the data back on column you inserted in step 1 above.