Delete empty rows for entire workbook

Copper Contributor

Hi Tech, 

 

Is there a way to delete all the empty rows in a workbook instead of by groups or individuals?

 

Thanks!

Aundria

1 Reply
Ah Ha!

Figure it out:

Filter top data row
Select the entire workbook(triangle between Row 1 and Column A)
Select the dropdown option in Column A
Uncheck all data leaving only the Blanks checked.
Right-click and select Delete Rows
Boom.