How to delete blank lines in Excel

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.