Remove rows with the Filter

Please purchase the course before starting the lesson.

If you spend lots of time deleting unnecessary rows manually, you will benefit from using the Data Filter to clean up data.

When your data looks like this and you are about to spend a few hours manually working through it to keep the red blocks below, consider using the data filter.

Remove unnecessary rows

Below you can see that after using the data filter, your data looks much cleaner.

Remove_unnecessary_rows_1

To see the full course contents click here.

Back to: Intermediate Excel Course > Filtering and Sorting