Select multiple values in Excel filters without scrolling

Hey everyone,

I’m trying to filter a column in Excel and select a few specific values (for example 4 item numbers), but they’re all over the list.

The problem is :

- If I use the checkbox list, I have to scroll through thousands of values to find them

- If I use the search bar, it resets or doesn’t let me easily combine multiple selections

- The "custom filter” only allows 2 conditions max

I've already searched online but couldn’t find a clear or simple solution.

This feels like such a basic use case, am I missing something obvious here ?

Is there a simple way to select multiple specific values without scrolling forever or using complicated formulas ?

Thanks for your help !

(Images in comments)