Share via

Format option is not visible in excel's find and replace menu

Anonymous
2023-09-07T16:17:41+00:00

Hi,

I have Excel 365, version 16.77) installed on my Mac.

When using Find and Replace the popup menu appears but the format option next to the Find what box is missing.

Attached I marked in red the missing format boxes

Thank you for your support

Microsoft 365 and Office | Excel | For education | MacOS

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. HansV 462.6K Reputation points MVP Volunteer Moderator
    2023-09-07T17:19:14+00:00

    Mac Excel doesn't have that functionality. It's an Excel for Windows feature only not found in the online web app, either.

    4 people found this answer helpful.
    0 comments

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. HansV 462.6K Reputation points MVP Volunteer Moderator
    2023-09-07T17:19:14+00:00

    Oh dear - it looks like that option is only available in Excel for Windows, not Excel for Mac...

    4 people found this answer helpful.
    0 comments
  2. Anonymous
    2023-09-07T17:13:10+00:00

    It does. But when I click on it nothing happens, only Replace and Replace All appears

    This is how it looks:

    1 person found this answer helpful.
    0 comments
  3. HansV 462.6K Reputation points MVP Volunteer Moderator
    2023-09-07T16:49:42+00:00

    Does the dialog have an "Options >>" button? If so, click it.

    0 comments