ssblue
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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
No problems, glad to help.
ASKER