Add Find all in the Mac app
IN the windows version you can click on the button find all when you are in a search box. This then shows you all cells which contain your search criteria in a list. Please add this feature to the Mac app, too!
Thanks for all your comments and votes supporting this suggestion. Please keep adding votes. We are considering this for a future update.
Thanks – Steve K [MS Excel]
Lauren Oram Thanks a million for your workaround. I helped me more than you can imagine
They really want to stick it to Mac users even more than they already do...We already can’t have Access, give us this!
It is a surprise that such a simple function is not implemented - or worse - was removed from the "regular" PC version as this was ported to MAC.
Ridiculous this doesn't exist after _6 years_ of begging. Come on MS...
Really crazy that did this doesn't exist. Google sheets here we come.
nancy lopez commented
This is comical... and I only say that because if you don't laugh then you'll cry.
PLEASE add this very basic function to the Mac App. Also, props to Lauren Oram below who posted an acceptable workaround. Get your **** together Excel!
Alexandru George commented
Michelle Niculescu commented
Please make this happen. It’s super frustrating.
Lauren Oram commented
Hi all! Just here to drop a solution if people are looking for find all in order to DELETE! In my case, I wanted to delete any row that had a cell containing the word "sold". Since, as all you know, there is no find all and delete for mac, I used this method:
1. under home tab, go to conditional formatting and select highlight cells rules. Highlight the cells based on whatever rule you need.
2. you can then sort the sheet by CELL COLOR! I sorted the sheet so that any rows with cell color were on top, then i deleted those rows! Easy to do once they are all grouped together, and not spread out between 2000+ rows. SO, select the whole sheet, under data tab click sort, then set the column and choose "cell color" under "sort on tab". press ok and voila!
3. Now just delete!
Hope this helps!
Legitimately unbelievable that this feature does not exist in Mac version
Find All Function for Mac commented
Are you guys purposely keeping this function off Mac or something? Absolutely ridiculous and wasting my time. C'mon now guys.
Right click on the cell with contents you would like to find, the click filter by -> cell value
this will produce essentially the same thing.
Sohan Yendal commented
Please add the feature!
There is no option to "Find All" within the find section.
We can find and REPLACE ALL but what if we just want to find all?
This is a feature in the Windows version
Cmon we've been waiting for this since forever.
Wow, this posting is 5 years old, fix it already!
please add the "find all" feature like there is on windows excel for years! the next find is just time consuming for me ...
Seriously ridiculous that there's no Find All feature for Mac. Don't know why this is proving so complicated, but please solve this problem!
I am new to Mac and I just found out there is no Find All in Excel for Mac!!!
This is definitely a deal breaker for me. I am going back to Windows.
Well played Microsoft!
Its in the windows version. Super basic feature. Has been requested for over 10 years... come on