Delete blank rows in Excel. Have a spreadsheet with blank rows that are spread throughout the worksheet? Instead of deleting each blank row individually, delete all blank rows at once.

For this to work, your header rows must be on the first row of the spreadsheet. Select the entire columns that contain your data by clicking on the letters at the very top of the columns. On the Data tab, Sort & Filter group, select Filter. Click the drop-down arrow on the right side of the first column of your data, uncheck Select All, and check Blanks.

If any numbers are still visible, go to the second column of your data and repeat the step above. Continue to repeat the steps for each column until no data appear. Select the filtered rows and go to the Home tab, Cells group, and select Delete. On the Data tab, Sort & Filter group, select Clear.