S
Steve
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
- 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