Forum Discussion
Delete empty rows for entire workbook
Hi Tech, Is there a way to delete all the empty rows in a workbook instead of by groups or individuals? Thanks! Aundria
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.
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.