Remove empty rows
Overview
Preview and remove entirely empty worksheet rows. Rows containing data or formulas are protected.
Use this after importing data or collecting edits that leave large gaps. Removing empty rows makes the worksheet easier to scan without removing populated rows.