Mac Excel Filter Problem - Return Key Doesnt Work for Search Function

ericmarui 

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.