Link to home
Start Free TrialLog in
Avatar of ssblue
ssblueFlag for United States of America

asked on

Excel won't look at entire list using a filter due to blank lines

Excel - I have a very long list of items that I want to use a filter on however there are blank lines through out the list which prevents the filter from seeing everything.

Is there a way to remove all the blank lines without scrolling down through the entire list?

Or perhaps someone knows of a better way to filter that look at the entire list.
ASKER CERTIFIED SOLUTION
Avatar of Rob Henson
Rob Henson
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of ssblue

ASKER

Thanks, I never knew that!
No problems, glad to help.