I'd turn off the autofilter (data|filter|autofilter), then select the range to
filter--not just the headers.

Then reapply data|filter|autofilter

Kathy wrote:

When applying autofilter, it seems to be defaulting to filter rows through
999. So even if data is entered only in a few rows, the next available row to
enter data is 1000 as long as the filter is applied.

For example, let's say there is data in rows 1-19. I turn on autofilter and
apply it. The only rows that contain filtered data are 2 and 17. So on the
screen I see rows 2 and 17, and the next row showing is 1000. I can't enter
new data in the blank rows between 20 and 1000 unless I turn off autofilter.

This is occuring in a workbook that we use as a template each week. It
didn't happen in older versions of the same workbook (both Excel 2003), and I
can't figure out what changed. There must be a setting somewhere that causes
autofilter to default to include rows 1-1000, instead of only the rows that
contain data. Help?

--

Dave Peterson