Forum Discussion

ADresen's avatar
ADresen
Copper Contributor
Jul 18, 2023

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

excel
  • ADresen's avatar
    ADresen
    Copper Contributor
    Jul 18, 2023
    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.

Resources