Problem with filtering columns in Excel 2007

R

Richard

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!
 
L

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

Similar Threads

Excel 2007 Filtering range 1
Autofilter: Does Not Contain 2
Getting no results from Advanced Filtering in Excel 2007 1
Filter (blanks) with two or more unique values not working 1
Excel 2007 compatibility issue - speed between cells 2
Excel Filtering doesn't work with large files 6
Horizontal filtering 8
Dynamic Filtering 2

Top