![]() |
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 |
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 11:58 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com