If there are many blank rows in your Excel sheet, you can delete them and tidy up the document using the "Find and Select" ...
You can delete a pivot table in Excel with a few clicks on a Mac or Windows PC. Here are two ways to do it.