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

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

Thank you Dave, you are a lifesaver. When you have so much data it sure is
nice to have the filtering working.

Curtis

"Dave Peterson" wrote:

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

"Curtis S." wrote in message
...
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?

Select the entire range, then turn on your filter.
--
David Biddulph