Every once in a while, you might find Excel behaving in a bizarre or unexpected way.
One example is when youaccidentally trigger the scroll lock feature.
Another example is when one or more formulas suddenly stops working.
This can be very confusing, and you might think you’ve somehow broken your spreadsheet.
However, it’s likely a simple problem.
With a little troubleshooting, you’re able to get things working again.
Show Formulas is meant to give you a quick way to see all formulas in a worksheet.
However, if you accidentally trigger this mode, it can be quite disorienting.
You should see formulas toggled on and off each time you use the shortcut.
Show Formulas toggles the display ofeveryformula in a worksheet.
If you are having trouble with asingleformula, the problem isn’t Show Formulas.
Instead, Excel probably thinks the formula is text.
Read on for more information.
There are several situations that might cause this behavior.
No equal sign
First, you may have forgotten the equal sign.
All formulas in Excel must begin with an equal sign (=).
In this case, the formula aboverequiresquotes around criteria.
If so, set the format to General (Control + ~), or another suitable number format.
Excel should then recognize the formula.
