Delete Blank Rows Excel sheet

To delete blank rows in an Excel sheet, you can follow these steps:

Method 1: Using Excel’s Built-In Tools
On the Home tab, in the Editing group, click Find & Select.

2- Click Go To Special.

3-Select Blanks and click OK.

Excel selects the blank cells automatically blanks rows selected.

4-On the Home tab, in the Cells group, click Delete then Click Delete Sheet Rows. .

now all blank rows delete as blow 

Method 2: Using a Filter

Method 2: Using a Filter

1. Select Your Data:
   • Select your data range, including any headers.
2. Apply a Filter:
   • Go to the Data tab and click on Filter.
3. Filter Blank Rows:
   • Click the filter drop-down arrow for the column where you suspect blanks are.
   • Uncheck everything except for Blanks, then click OK.
4. Delete Filtered Rows:
   • Select the filtered rows (the blank rows will now be visible).
   • Right-click the row numbers and select Delete Row.
5. Remove Filter:
   • Select your data range, including any headers.

flow this one