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!
Florian
shared this idea
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]
116 comments
-
Anonymous
commented
Lauren Oram Thanks a million for your workaround. I helped me more than you can imagine
-
Steve
commented
They really want to stick it to Mac users even more than they already do...We already can’t have Access, give us this!
-
Chaz
commented
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.
-
luckman212
commented
Ridiculous this doesn't exist after _6 years_ of begging. Come on MS...
-
Apo
commented
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
+1
-
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!
Lauren Oram -
Anonymous
commented
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.
-
Anonymous
commented
WORKAROUND:
Right click on the cell with contents you would like to find, the click filter by -> cell valuethis will produce essentially the same thing.
-
Sohan Yendal
commented
Please add the feature!
-
LB
commented
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 -
Anonymous
commented
Cmon we've been waiting for this since forever.
-
Anonymous
commented
Wow, this posting is 5 years old, fix it already!
-
Anonymous
commented
please add the "find all" feature like there is on windows excel for years! the next find is just time consuming for me ...
-
Gretchen
commented
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!
-
Sasha
commented
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! -
Anonymous
commented
Its in the windows version. Super basic feature. Has been requested for over 10 years... come on