G
Guest
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?
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?