Autofilter not working properly

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When a column is autofiltered for blanks or nonblanks, the
next available row for data entry is wrong ie: the last
populated row is 300, but the row immediately below the
filtered area is something like 3275 (random figure). Any
ideas please, as this is driving me mad
 
Hi,
Does this problem happen when you highlite the range, then
turn on autofilter? If not, you may have cells which at
one time had data in them and Excel needs to reset the
last cell.
Have a look at:
Last Cell - Resetting
http://www.mvps.org/dmcritchie/excel/lastcell.htm
You may have cells which at one time had data in them and
Excel needs to reset the last cell. Does this problem
happen when you highlite the range, then turn on
autofilter?
 
You must log in or register to reply here.

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

Autofilter misses last line 7
Filter not showing blanks option 6
Any way to autofilter at seperate points on the same sheet? 3
Autofilter Not working completely 2
Excel 2003 1
Excel 2003 - Autofilter Question 4
Conditional Autofilter For Formula 4
Default filter range 5

Back
Top