View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Filtering Problem

If you have blank rows in your data, and you let excel guess what range should
be filtered, you may see this problem.

I'd remove the data|filter|autofilter
Then select the complete range
and reapply data|filter|autofilter.

Curtis S. wrote:

I have been building an Excel 2002 spreadsheet here at work. I have a total
of 6781 lines and my columns are up to "Y" . My problem is that any of my
entries past line 6726 will not filter out when I use any of the column
filters. Everything sorts in fine. Is there any limits to this version?

Thank you,
Curtis


--

Dave Peterson