How do I delete empty rows from the Excel table?
To remove empty rows, proceed as follows:
- Select the range where you want the blank rows removed.
- Go to the Tab "data" and click on "Filter". The first entries in the respective columns have to be transformed into a drop-down menu.
- Click in a drop-down item at the arrow. Uncheck the "select All" and select the entry "Empty".
- Repeat with the other columns.
- Select all of the blue highlighted lines. Click with a right click on the selection and select "line clear".
- To get back to the normal view, click in the "data" Tab to "Filter".
