If you copy data from various tables and data sources into an Excel spreadsheet, you might end up with multiple blank rows and columns. If it’s more than just a few, trying to delete them would be a pain. Instead, you can use this technique to get rid of all those empty cells.
Here I have a spreadsheet with a few blank rows:
In order to select all the blank information, I can click on Find & Select > Go To Special:
On the Go To Special dialog box, I select Blanks and click OK:
You can see how all the blank cells are now selected:
To delete the selected rows (or columns if that is where the blanks are), select Delete > Delete Sheet Rows:
You now have a spreadsheet with all the empty rows eliminated:
One Minute Office Magic 