Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to stop the last record always appearing when I Autofilter
I have a table of approx 1200 records and when I use Autofilter to select
specifc records the last record in my table always appears. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to stop the last record always appearing when I Autofilter
Next time you apply a filter to that range, notice that the dropdown arrow has
changed color to blue for that column. And the row indicators for the range that's filtered are blue. But that last row that shows up, but doesn't match the filter as a row indicator of black/normal. This means that that row is not part of the filter range. So remove the data|Filter|autofilter and select all the range and re-apply data|filter|autofilter. TAG wrote: I have a table of approx 1200 records and when I use Autofilter to select specifc records the last record in my table always appears. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to stop/ restart macro after selecting from autofilter list | Excel Discussion (Misc queries) | |||
Lost Record count when using Autofilter | Excel Discussion (Misc queries) | |||
Marcro recroding/ stop Ikon not appearing in middle of excel sheet | Excel Discussion (Misc queries) | |||
How do I stop Filter Mode from appearing in the status bar | Excel Discussion (Misc queries) | |||
Autofilter record count | Excel Discussion (Misc queries) |