Share via

Excel Formula Helper Turned Off

Anonymous
2021-08-29T21:11:18+00:00

I am not getting the formula hints below after you select a certain formula. For example, when you choose a sum formula, in a little box below, it should say SUM(number1,[number2],...). I am not getting this help of what to input when using these formulas.

Microsoft 365 and Office | Excel | For home | Windows

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

Bob Jones AKA CyberTaz MVP 436.1K Reputation points
2021-08-30T13:34:14+00:00

I'm sure Shane appreciates your gratitude but I'm not so sure how it could be helpful unless you were able to interpret it for Mac Excel. Those steps are for the Windows product... as written they cannot be followed in Excel for Mac :-) On a Mac:

  • Go to Excel> Preferences> View then check the box for Function Screen Tips.

You also may want to visit Excel> Preferences> AutoComplete to confirm the appropriate boxes are checked for those options as well.

Was this answer helpful?

2 people found this answer helpful.
0 comments

4 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2021-08-29T21:40:57+00:00

    Hi,

    Choose File, Options (or More, Options), Advanced, and under Display, and turn on Show function screen tips.

    Was this answer helpful?

    10+ people found this answer helpful.
    0 comments
  2. Anonymous
    2021-08-30T20:07:41+00:00

    Bob Jones AKA: CyberTaz

    "I'm not so sure how it could be helpful"

    I don't have a working Mac so the best I can do is give an idea how it's done on a PC. These suggestions sometimes help users of different versions and even different OS's.

    I had a nice new Mac Pro desktop (cylinder) but it overheated and burned out the SSDs. It was 1 month out of warranty and Apple refused to cover it. They knew of the overheating issue and never made another Mac Pro of this type; they have now gone back to the standard desktop ignoring the "Cylinder".

    Bob, as I understand it the goal of this site is to exchange ideas. If you don't believe a response is good, just submit your own.

    Was this answer helpful?

    3 people found this answer helpful.
    0 comments
  3. Bob Jones AKA CyberTaz MVP 436.1K Reputation points
    2021-08-30T20:51:38+00:00

    No criticism intended. Just explaining to the OP why s/he might be having difficulty following the steps.

    Sorry to hear about the Pro. Did Apple do nothing to compensate those who were affected?

    Was this answer helpful?

    0 comments
  4. Anonymous
    2021-08-30T00:14:32+00:00

    Thank you!

    Was this answer helpful?

    0 comments