Share via

Custom Filter for text values

Anonymous
2023-08-22T22:43:09+00:00

Excel 365

Windows 11

I am not sure if this behavior is intended, but I'm leaning towards no. When I try to use the Custom Filter option for a column with text values, it is giving me both the text filters and the number filters, which isn't helpful. The table column I'm attempting to filter is called Notes, and is comprised of text, although there are a few instances where a number is mixed in with the text, and sometimes it has nothing in the cell. To bridge the issue, I tried explicitly setting the column to text, no luck. Restarted Excel as well.

Microsoft 365 and Office | Excel | For home | 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. Ashish Mathur 101K Reputation points Volunteer Moderator
    2023-08-22T23:31:25+00:00

    Hi,

    That is the intended behavour. All filter comparison show up in the drop down of the Custom Auto filter window.

    0 comments