Forum Discussion
Mac Excel Filter Problem - Return Key Doesnt Work for Search Function
I will admit, as a Mac user with a fair amount of experience with databases, data tables, to not knowing what you are referring to when you talk of using "the Excel filter" -- which filter do you mean? Is it this..
..and if so, is the "Auto Apply" down at the bottom there de-selected?
Or is it this...
Is it something else altogether?
Or are you using the new FILTER function in a formula. Pretty sure it's not that.
My point being, though, that there is not just a single "the Excel filter"--just as in so many other aspects of Excel, there are multiple ways to filter, to search, to screen through a list or database. So if you continue to face this dilemma, please come back with a more compete scenario.
An immaterial aside: there is a Mac Excel 16.70 now available; I'm sure this is not a factor in your question, but just wanted to alert you to it.