I was doing some work with a client a while ago and encountered a problem with Excel where it was showing me the formula in a call, rather than the result of the formula. I have no idea if the spreadsheet was sent to me with the formulas set this way (I’m not sure if this is possible) or if I inadvertently hit the keyboard combination to enable the setting at some point (Alt + M and then Alt + H).
It took me longer than it should have done to revert Excel back, so I am posting this as a reminder should it happen again.
To switch this setting off, select the Formulas tab on the action pane and, under Formula Auditing, click Show Formulas, which will toggle the setting off (or on if it is currently off):
What should we write about next?
If there is a topic which fits the typical ones of this site, which you would like to see me write about, please use the form, below, to submit your idea.