Instructions to delete blank lines (blank lines) in Excel

The data in the Excel document file that you are referencing has many blank cells and blank lines that cause the Excel file to reverse the data position. You want to delete all the empty cells in that data file but if you delete each cell one by one, it will take a lot of time.

Instead of deleting cells one by one, you can delete empty rows or empty columns to shorten the operation time.

The following article shows you how to delete blank lines in Excel 2013, with Excel 2010 and 2007 you do the same.

Method 1

Step 1: First you need to select the data to be deleted, you can select the entire data in the sheet using the key combination Ctrl + A .

Instructions to delete blank lines (blank lines) in Excel Picture 1

Step 2: Next, select the Home tab -> Find & Select -> Go To Special (or press Ctrl + G and select Special ).

Instructions to delete blank lines (blank lines) in Excel Picture 2

Step 3: The Go To Special dialog box appears, select Blanks and click OK .

Instructions to delete blank lines (blank lines) in Excel Picture 3

Step 4: Now all blank cells are selected, you select the Home tab -> Delete -> Delete Sheet Rows to delete blank lines.

Instructions to delete blank lines (blank lines) in Excel Picture 4

If you want to delete empty columns, then select Delete -> Delete Sheet Columns .

Instructions to delete blank lines (blank lines) in Excel Picture 5

If you want to delete all blank cells, then right-click and select Delete (or press Ctrl + - ) to open the Delete dialog box .

Instructions to delete blank lines (blank lines) in Excel Picture 6

Here you can leave the default Shift cells up or you can select Entire row or Entire column to change surrounding cells. Click OK to delete the empty data box.

Instructions to delete blank lines (blank lines) in Excel Picture 7

Method 2

Step 1: Select the data you want to delete blank lines or you can select the entire data with Ctrl + A combination .

Instructions to delete blank lines (blank lines) in Excel Picture 8

Step 2: Select the Data tab , in the Sort & Filter section you choose Filter .

Instructions to delete blank lines (blank lines) in Excel Picture 9

Step 3: Next, select the arrow icon in the first cell of any column. Here you deselect in the Select All section .

Instructions to delete blank lines (blank lines) in Excel Picture 10

Step 4: Drag the scroll bar right down to the bottom and select the Blanks box and click OK .

Instructions to delete blank lines (blank lines) in Excel Picture 11

Step 5: Now the blank lines will be filtered, you select the tab Home -> Delete -> Delete Sheet Rows to delete the blank lines.

Instructions to delete blank lines (blank lines) in Excel Picture 12

Also you can use VBA to delete blank lines, but that is a bit complicated for those who are not familiar with VBA. So you only need to use one of the two methods above to quickly delete blank lines in Excel. Good luck!