Question

Excel: delete empty lines - this is how it works

Answer 1

Delete empty rows in Excel
1st step:
2nd step:
3rd step:
4th step:
5th step:
6th step:
quick start Guide

---

Would you like to remove blank lines from your Excel spreadsheet? We'll show you how!

Empty lines in Excel tables can help with clarity during creation. Unfortunately, once the table is created, the rows do exactly the opposite. It can therefore be advantageous to delete the empty rows in the table. We'll show you how to do this in the following tip.

Note: The deletion only works with whole blank lines. So if you have blank lines with individual entries, you can always delete the blank lines manually..

Delete empty rows in Excel

Follow our step-by-step instructions or take a look at the brief instructions .

1st step:

Select all cells from which you want to remove the blank lines. You can select the entire column by clicking on the name of the column at the very top. To do this, just click on the column name, such as "A".

2nd step:

Then click on " Search and Select " in the " Start " menu . A small drop-down menu opens in which you have to select " Go to ... ".

3rd step:

Now a new window will open. At the bottom left there is a button labeled " Contents ... ". Click on this.

4th step:

Now select the point " Empty cells ". Confirm this selection with a click on " OK ". All empty cells in your table are then automatically selected.

5th step:

In the " Start " tab, click on the small arrow next to the " Delete " item . In the drop-down menu you now have to click on " Delete cells ... ".

6th step:

Now you just have to select " Whole Line " in the new window and click " OK ". After that, all blank lines are automatically deleted from your Excel table. Normally, cell references remain correct.

quick start Guide

1. Select all the parts of your table from which you want to remove the empty rows. With a click on the column name at the top (e.g. column A), you can mark entire columns.
2. Then click on the " Search and Select " option in the " Start " tab . In the submenu you have to select the item " Go to ... ".
3. A new window is opening up. Here click on the " Contents ... " button .
4. In the next window select the item " Empty cells " and press " OK ". All empty cells in your table are now automatically selected.
5. Now click on the arrow next to the " Delete " tab in the " Start " tab . Select " Delete cells " there.
6. Then select the Entire Row option, then click OK . Your blank lines will now be automatically removed from the selected columns in your Excel table.

---