ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Autofiltering limitations and rules (https://www.excelbanter.com/excel-discussion-misc-queries/186898-autofiltering-limitations-rules.html)

Jane

Autofiltering limitations and rules
 
I know that there is a maximum number of records you can filter. We have a
spreadsheet that has data in columns C - R. Columns A & B, however, do not
have headings and are more of a "reminder note" to the creator of the
workbook. Column C also has merged cells in some of the rows. We have noted
that in row 9 columns A & B do not contain information. If I do the
autofilter in row 7 and I click on the down arrows in any of the columns, all
I see in the column c grouping is "All, Custom, Top 10" and Athletic/HS.

Is there a limitation as to blank cells (either in rows or columns)?

Thanks,
Jane

KC Rippstein hotmail com>

Autofiltering limitations and rules
 
Excel does not always "guess" the correct autofilter range. As long as some
of the columns have data along a row, it shouldn't matter if the first cell
of that row is blank...it should have guessed correctly that as long as the
row has some data, your list is still going strong.

Try selecting the entire range ahead of time then selecting DataAutoFilter
to see if that helps. I am afraid, though, that the merged cells in column C
will probably cause errors.

--
Please remember to indicate when the post is answered so others can benefit
from it later.


"Jane" wrote:

I know that there is a maximum number of records you can filter. We have a
spreadsheet that has data in columns C - R. Columns A & B, however, do not
have headings and are more of a "reminder note" to the creator of the
workbook. Column C also has merged cells in some of the rows. We have noted
that in row 9 columns A & B do not contain information. If I do the
autofilter in row 7 and I click on the down arrows in any of the columns, all
I see in the column c grouping is "All, Custom, Top 10" and Athletic/HS.

Is there a limitation as to blank cells (either in rows or columns)?

Thanks,
Jane



All times are GMT +1. The time now is 12:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com