Share via

Where to find File>Options>Advanced tabs in Excel on Macbook?

Anonymous
2024-01-09T17:37:04+00:00

Hi!

I am a new Macbook user and am searching for the File>Options>Advanced tabs in Excel to hide all cells with 0 values in the Excel file. How do I do that?

Thank you.

Best regards,

Stella

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. Bob Jones AKA CyberTaz MVP 435K Reputation points
    2024-01-12T17:22:37+00:00

    In case you haven't located it yet, go to Excel> Preferences> View then clear the check for Zero Values. Note that it affects only the active sheet so you need to select multiple sheets or individually apply the setting.

    4 people found this answer helpful.
    0 comments

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Bob Jones AKA CyberTaz MVP 435K Reputation points
    2024-01-09T19:12:27+00:00

    For future reference, any time you see File> Options it's referring to the Windows version of the program. Most online resources fail to make the distinction or don't even realize that there are differences to be addressed. Even the Mac Office Help files can be strictly Windows oriented on some topics.

    To reduce - but not eliminate - Windows-specific hits always include something like for mac in the search criteria.

    1 person found this answer helpful.
    0 comments
  2. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  3. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more