Share via

Filter range is not including all rows.

Anonymous
2023-01-17T16:13:58+00:00

My filter range does not include all of the rows in it's criteria selection or when I apply a filter. The filter range seems to only be rows 1 through 20. The image is showing the filter selection options based on values in rows 2 through 20. As you can see "ROB" is not an option to filter because he appears for the first time in row 30.

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Rory Archibald 18,965 Reputation points Volunteer Moderator
    2023-01-17T17:09:42+00:00

    There's no image but I'll take a guess: usually this suggests that either the first 20 rows were selected when applying the filter, or there's a blank row at row 21.

    Was this answer helpful?

    0 comments