If Microsoft Excel is showing formulas instead of calculated results, it can be confusing—especially when you expect to see numbers, dates, or text outputs. Instead of values, Excel displays formulas like =SUM(A1:A5) directly in the cells.
In most cases, this behavior is caused by Show Formulas mode being enabled, incorrect cell formatting, or minor worksheet settings, not a broken Excel file. The fixes below will help you restore normal calculation results quickly.
How to Fix Excel Showing Formulas Instead of Results
Follow the steps in order. After each step, check whether Excel starts showing results instead of formulas.
1. Turn Off “Show Formulas” Mode (Most Common Fix)
Excel has a built-in toggle that displays all formulas.
- Open Microsoft Excel
- Press Ctrl + ` (the key above Tab, below Esc)
- Check if formulas instantly turn into results
This keyboard shortcut toggles Show Formulas on and off.
2. Disable Show Formulas from the Ribbon
If the shortcut doesn’t help, disable it manually.
- Open Excel
- Go to the Formulas tab
- Click Show Formulas to turn it off
Once disabled, Excel will display calculated values again.
3. Change Cell Format from Text to General
If cells are formatted as Text, Excel treats formulas as plain text.
- Select the affected cells
- Go to the Home tab
- In the Number group, change format from Text to General
- Double-click each cell and press Enter
This forces Excel to re-evaluate the formula.
4. Remove the Apostrophe Before the Formula
A leading apostrophe forces Excel to display formulas.
- Click the cell showing the formula
- Check if the formula starts with
'=instead of= - Remove the apostrophe
- Press Enter
The formula will now calculate normally.
5. Check If Calculation Mode Is Set to Manual
Manual calculation can prevent results from updating.
- Go to the Formulas tab
- Click Calculation Options
- Select Automatic
Excel will recalculate formulas automatically.
6. Force Excel to Recalculate All Formulas
Sometimes Excel doesn’t refresh calculations properly.
- Press Ctrl + Alt + F9
- Wait a few seconds
- Check if results appear
This forces a full recalculation of the workbook.
7. Check for Formula Errors
Errors can stop Excel from showing expected results.
- Look for error indicators like:
#VALUE!#REF!#NAME?
- Fix any incorrect cell references or functions
- Re-enter the formula if needed
Incorrect formulas may appear as plain text.
8. Turn Off Formula View for Individual Worksheets
Formula view applies to the entire workbook.
- Switch to another worksheet
- Press Ctrl + ` again
- Return to the original worksheet
This refreshes the display state.
9. Check for Compatibility or Protected Mode
Files from external sources may open differently.
- If Excel opens in Protected View, click Enable Editing
- Save the file as a new workbook
- Reopen the saved file
Protected or compatibility modes can affect display behavior.
10. Restart Excel or Repair Office (Last Resort)
If the issue persists across all files:
- Close Excel completely
- Restart your PC
- Test with a new blank workbook
- If needed, repair Microsoft Office from Apps settings
Persistent issues may indicate corrupted program files.
Final Thoughts
Excel showing formulas instead of results is a display or formatting issue, not a calculation error. In most cases, pressing Ctrl + ` or changing the cell format to General fixes the problem instantly.
To avoid this in the future, be careful when importing data, check cell formatting, and ensure calculation mode is set to Automatic.
