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.

How to delete blank lines in Excel Picture 1

+ Step 2: Press the key combination Ctrl + G , a dialog box appears.

+ Step 3: Select the Speciel item as shown.

How to delete blank lines in Excel Picture 2

+ Step 4: Click Blanks

How to delete blank lines in Excel Picture 3

+ Step 5: Select Home Tab, click the Delete icon on the Toolbar.

How to delete blank lines in Excel Picture 4

After completing the above steps, the white lines will disappear.

2. Method 2

+ Step 1: Select all data, go to Data tab, select Filter.

How to delete blank lines in Excel Picture 5

+ 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.

How to delete blank lines in Excel Picture 6

+ Step 4: Go to Home, select the Deleta icon on the Toolbar.

How to delete blank lines in Excel Picture 7

Or Right-click to delete.

How to delete blank lines in Excel Picture 8