In the case of small data, it can be done manually to delete, but for large data, this method will not be possible because it takes too much time.
1. Method 1
+ Step 1: Select all data to be deleted.
+ Step 2: Press the key combination Ctrl + G , a dialog box appears.
+ Step 3: Select the Speciel item as shown.
+ Step 4: Click Blanks
+ Step 5: Select Home Tab, click the Delete icon on the Toolbar.
After completing the above steps, the white lines will disappear.
2. Method 2
+ Step 1: Select all data, go to Data tab, select Filter.
+ Step 2: Deselect Select All and drag the slider to the bottom.
+ Step 3: Check Blanks and select OK.All blank lines will be filtered.
+ Step 4: Go to Home, select the Deleta icon on the Toolbar.
Or Right-click to delete.