Delete All Empty Rows

This tool removes all completely empty rows within the dataset on your worksheet.

Deleting these blank rows makes your worksheet less cluttered and easier to navigate.
With fewer unnecessary gaps, your data is more organized and professional-looking, which helps when you use tables, sort, filter, or analyze the information.

Tip: To remove only the empty rows within a specific range, use our "Select, Hide, or Delete Rows or Columns Based on Custom Criteria..." tool.

Starting this tool

Additional keywords to help you find this tool:
Delete all empty rows, Remove blank rows in Excel, Delete blank rows, Remove empty rows from worksheet, Clean up empty rows in Excel, Delete blank lines, Clean up worksheet empty rows

Tip:Alt+P for the previous tool.