Feedback by UserVoice

 

How can we improve Excel for Mac?

← Excel for Mac

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!

356 votes

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

Florian shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

114 comments

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Chaz commented  ·   ·  Flag as inappropriate

    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.

  • Apo commented  ·   ·  Flag as inappropriate

    Really crazy that did this doesn't exist. Google sheets here we come.

  • nancy lopez commented  ·   ·  Flag as inappropriate

    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!

  • Lauren Oram commented  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    WORKAROUND:
    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.

  • LB commented  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    Its in the windows version. Super basic feature. Has been requested for over 10 years... come on

  • Rahma commented  ·   ·  Flag as inappropriate

    Are you kidding me, such an important feature! and it's not available, and you want us to vote for it? this doesn't need a vote !!

  • Ozkan Gelincik commented  ·   ·  Flag as inappropriate

    Please add all essential functionalities of Excel into Mac version! Especially Find All! Thank you 🙏

← Previous 1 3 4 5 6

Excel for Mac: Viewing / Navigating Workbooks

Categories

Feedback and Knowledge Base

(thinking…)