Discover new tools to get things done.
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.
Specify a Keyboard Shortcut: ASAP Utilities › My Tools & Shortcuts › Manage My Tools & Shortcuts...
Tip:Alt+P for the previous tool.
Tip: Alt+N for the next tool.