Autofilter Not working completely
 

Here are the specifics:
- Using Excel 2003
- Have several workbooks which were built alike.
- Set autofilter on all of the columns which is about 10.
- The number of rows is about 40
- There is a row of data then a row that is a merge and center cell that
spans all ten columns. This row is filled in with color which is used as a
visible separator and a data descriptor. The data row and separator
alternates down the spreadsheet.

Four of the six workbooks without problems. When working the autofilter,
once a criteria is selected, will display only those rows that match the
criteria. It excludes all rows that don't match to include the separator
rows.

However, for some reason two of the workbooks don't filter all the data. It
filters a subset of the data which are grouped in consecutive rows at the
top, but it also continues to display the separator rows and other rows that
don't match. There are rows further down that do match the criteria but are
not grouped at the top and are displayed in the normal order. This scenario
occurs for each column within the worksheet. Is there some way that rows
after a certain point are excluded from the filter? If so, how is this done
and how can I correct it? Is there a way to visually see any conditions or
restrictions that may be in place. Similar to the Paragraph button in MS
Word where it shows you all the hidden characters (spaces, carriage returns,
etc.).

Thanks in advance for your assistance.

Steve

Autofilter Not working completely
 

- Set autofilter on all of the columns which is about 10.

To avoid ambiguity, I'd select the entire cols -- not just the top row
cells, then apply autofilter. Or, select the entire range including the top
row cells, then apply autofilter.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,500 Files:362 Subscribers:62
xdemechanik
---

Autofilter Not working completely
 

If there is a blank row between data, auto filter will ignore everything
after the blank row.
--
Carrie


"Steve" wrote:

Here are the specifics:
- Using Excel 2003
- Have several workbooks which were built alike.
- Set autofilter on all of the columns which is about 10.
- The number of rows is about 40
- There is a row of data then a row that is a merge and center cell that
spans all ten columns. This row is filled in with color which is used as a
visible separator and a data descriptor. The data row and separator
alternates down the spreadsheet.

Four of the six workbooks without problems. When working the autofilter,
once a criteria is selected, will display only those rows that match the
criteria. It excludes all rows that don't match to include the separator
rows.

However, for some reason two of the workbooks don't filter all the data. It
filters a subset of the data which are grouped in consecutive rows at the
top, but it also continues to display the separator rows and other rows that
don't match. There are rows further down that do match the criteria but are
not grouped at the top and are displayed in the normal order. This scenario
occurs for each column within the worksheet. Is there some way that rows
after a certain point are excluded from the filter? If so, how is this done
and how can I correct it? Is there a way to visually see any conditions or
restrictions that may be in place. Similar to the Paragraph button in MS
Word where it shows you all the hidden characters (spaces, carriage returns,
etc.).

Thanks in advance for your assistance.

Steve