Excel: delete empty lines - how it works
Related Videos: How to Delete Blank Rows in Excel (May 2024).
Since completely empty lines can be annoying in Excel, you can simply delete them. We show you how it works.
How do I delete blank rows from the Excel spreadsheet?
To remove blank lines, do the following:
- Select the area where you want to remove the blank lines.
- Go to the "Data" tab and click on "Filter". The first entries in the respective columns have been transformed into a dropdown menu.
- Click the arrow in a drop-down element. Remove the checkmark at "Select all" and activate the entry "Empty".
- Repeat with the other columns.
- Select all the lines highlighted in blue. Right click on the selection and select "Delete Row".
- To get the normal view again, click on "Filter" in the "Data" tab.