Problem with filtering columns in Excel 2007



I'm trying to filter out blanks from a particular column but when I select
that with auto-filter, only the first 246 lines are filtered, The remaining
columns are still displaying blanks.

Before applying the filter I make sure that all filters were cleared. I also
checked that the unfiltered cells did not contain any invisible spaces.

I would be grateful if anyone can through any light on the problem! Thanks!

Luke M

Before activating the autofilters, make sure you entire range of info is
selected. It sounds like XL is only including the first 246 rows of data in
the dataset to be filtered.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question