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