When you will have a sheet full of Excel formulas, you will also need to quickly check how each formula looks like because I really do want to see. This will be good if you want to do spreadsheet auditing. It is easy to do in your Excel.

Previously In Excel FormulasHow to Round Off Numbers in Excel?

This will be my sample worksheet with formulas for this tutorial:

Show & Hide Formulas in Excel in 2 Simple Steps 1

Below are the steps given below to follow in your Excel:

STEP1: Open Options Menu

To set this via Excel Options, prefer another way written below:

Go to File > Options

Show & Hide Formulas in Excel in 2 Simple Steps 2

STEP2: Show or Hide Formulas With Single Click

Now follow this:

Go to Advanced> Display Options for this Worksheet > Show formulas in cells instead of their calculated fields

Show & Hide Formulas in Excel in 2 Simple Steps 3