Excel showing formula instead of result shortcut

Have you ever been working on an Excel spreadsheet, only to find that the formula you entered isn’t showing the result you expected?

Sometimes, Excel shows the formula instead of the value / result, instead of giving you the calculated value.

Below is an example where I entered the formula in the Profit column, and I see the formula instead of the value.

This is something that’s quite common and happens to a lot of users.

There could be multiple reasons behind Excel showing the formula instead of the result, and in this tutorial, I will show you the potential fixes that will make this issue disappear.

So let’s get started!

Reason #1 – Show Formulas May Be Enabled (Top Reason for Formulas Showing as Text)

In some cases, people actually want to see all formulas as text in the worksheet.

There could be multiple reasons for this – the most common one is when you’re auditing the worksheet and need to know where and what formulas are being used.

This problem has an easy fix – you just need to disable the ‘Show Formulas&#