Скачать или смотреть How to Delete Empty Rows in Excel In 2 Simple Step

Step 1: Select the blanks

Select your data: Manually highlight the range of cells containing your data or press Ctrl + A to select the entire sheet.

Open Go To Special: Press Ctrl + G (or F5) to open the Go To dialog box.
Select Blanks: Click the Special... button in the Go To dialog. In the "Go To Special" dialog box, select the Blanks radio button and click OK. This action will select all the blank cells in your chosen range.

Step 2: Delete the entire row

Delete the selection: With the blank cells highlighted, right-click on any of the selected cells to open the context menu.

Choose Entire row: Select the Delete... option, and then choose Entire row from the "Delete" dialog box.
Confirm deletion: Click OK to delete the blank rows