Four ways to delete blank lines in Excel

Working with a huge amount of data in Excel tables, you can inadvertently leave empty rows, which in some cases is completely unacceptable. This article will discuss how to remove blank lines in Excel. Four ways will be presented to help you do this. It is advisable to read the article before the final, so that in the end you decide for yourself how to use it, since they are quite different from each other.

Easy removal

First, let's figure out how to delete empty lines in Excel in the simplest way that almost all inexperienced users use, but in some cases it is the best way to use this removal.

So, to remove the extra empty lines in the program, you need:

1. Initially select the area of ​​the table that contains unnecessary rows.
2. Then press the right mouse button to bring up the context menu.
3. In the list, click on the line "Delete".

After that, a window will appear in which you must choose what needs to be deleted. In our case, these are strings, so select the "String" item and click "OK." Now all extra rows will be deleted from the table. However, you can speed up this process by skipping the steps to invoke the context menu. To do this, simply select the unnecessary lines and press the key combination "CTRL + -".

There is also an alternative. After highlighting the lines, you can go to the "Home" tab and there on the toolbar from the "Delete" drop-down list, select the "Delete lines from sheet" option, which is also quite convenient.

Sorting

The first way, as in Excel, to delete empty rows, we have sorted. However, it is not very convenient if you need to delete many lines, because you have to select them for a rather long time. That is why we will now tell you how to delete empty rows in Excel using the Sort tool.

So, you need to do the following:

1. Select the entire table. To do this, press the "CTRL + A" button.
2. Right-click on the table and in the menu click on the "Sort" line.
3. From the additional menu you need to select one of the items, in accordance with what type of data is in the table.

As soon as you make a choice, all empty rows that were in the table will move to its bottom and it will be easier to select and delete them using the method that was given first.

Using filter

In Excel, duplicate rows that are empty can be removed using a filter. Without ranting a lot, we will go directly to the instruction itself:

1. Initially, you need to select an area of ​​your table. To do this, hold down the left mouse button in its upper left corner, drag it to the lower right.
2. Next, go to the "Home" tab and click on the "Sort and Filter" button, and select "Filter" in the context menu.
3. As soon as you do this, issuing lists will appear in the column header, you need to expand one of them (any).
4. In the menu that appeared, you need to uncheck the "Empty" item and click "OK".

That's all, as you can see, the third way, how to remove extra rows in Excel, is much more convenient than some of the previous ones.

Selection

Finally, we will talk about another interesting way, how to remove empty rows from a table. This time we will use the selection of cells, which is carried out using a special tool. But first things first:

1. Again select the entire table in which the data you need and directly the empty rows are located.
2. Go to the "Home" tab and click on "Find and Highlight".
3. In the menu that appears, you need to click on the line "Select a group of cells."
4. In the menu that appears, you need to set the switch to "empty cells" and click the "OK" button.

Now all empty lines are selected and you can delete them. To do this, as in the first method, click on the "Delete" button in the toolbar of the "Home" tab.