EDUCBA Logo

EDUCBA

MENUMENU
  • Explore
    • EDUCBA Pro
    • PRO Bundles
    • Featured Skills
    • New & Trending
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Log in
  • Sign Up
Home Excel Excel Resources Excel Tips Excel Show Formula
 

Excel Show Formula

Madhuri Thakur
Article byMadhuri Thakur

Updated August 16, 2023

Show Formula in Excel

 

 

Show Formula in Excel

Show Formula in Excel helps the user see the formulas in any cell of the worksheet, showing all the formula types and lengths. To see the formulas in any cell, go to the Formula menu tab, and under the Formula Auditing section, select Show Formula. We can use this option to show the formula, print it, and hide its value instead of seeing it. First, to print the formula, go to the File menu and, from the Options section, check the Show formula box in the cell. And if we see the print preview, it will show the formula instead of the value.

Watch our Demo Courses and Videos

Valuation, Hadoop, Excel, Mobile Apps, Web Development & many more.

How to Show Formula in Excel Instead of the Values?

There are different ways by which we can show the formulas in Excel. They are listed below, along with the relative examples and screenshots. This will help to understand different ways to show formulas in Excel worksheets.

You can download this Show Formula Excel Template here – Show Formula Excel Template

Here is the sample data used for examples:

Show Formulas in MS Excel 1-1

We will look at a few examples to understand this better.

Example #1 – Double-Clicking a Single Cell to Exhibit the Formula

  • If you want to see a single cell formula that shows the result, just double click on that cell as below. You can also then edit it:

SUM Formula 1-2

  • If you want to see the formula in all the cells of column F, then select the cells below:

Show Formulas in MS Excel 1-3

  • Now, you have to go to the formula tab and click on the Show Formulas Excel option as below:

Show Formulas in MS Excel 1-4

  • Once you have clicked the Show Formula tab, then you will see the formulas in the cells of column F as below:

Show Formulas in MS Excel 1-5

Example #2 – Show Formula in Excel

  • Another example from the above data:

Show Formulas in MS Excel 2-1

  • Now select all the cells from column F:

Show Formulas in MS Excel 2-2

  • Now click the Show Formula tab, then you will see the formulas in the cells of column F as below:

Show Formulas in MS Excel 2-3

  • Placing the Cursor before the Formula would show the Formula in that cell.

Show Formulas in MS Excel 2-4

This shows the formula rather than the result.

Example #3 – By Enabling Show Formula in Workbook Option

  • Go to the File option, now go to Options.

Options Menu Excel 2-5

  • Now go to Advanced, scroll down a bit, and then under the heading ” Display options for this worksheet “, just check the box Show Formulas in cells instead of their calculated values. Press OK.

Show Formulas in MS Excel 2-6

This might look like a lengthy process, but it is very handy if you want to show the formula for multiple sheets.

  • In case you want to disable this option, just follow the same path, which is File, then Options, then Advanced < heading “Display options for this workbook“.
  • Uncheck the box ” Show formulas in cells instead of calculated results.”

Show Formulas in MS Excel 2-7

Example #4 – Keyboard Shortcut to see the Formula of a Workbook

The keyboard short cut keys are ( CTRL +` ). You can find Ctrl on the left side and the ` right above Tab button on the right side of your keyboard.

keyboard short cut keys Excel 3-1

Press them, and then you would be able to see every Formula in the spreadsheet, but other cells won’t be changed.

Adding an Apostrophe at the Start of the Cell Containing the Formula.

Just add ‘ in front of the formula so that it can be seen in the cell containing the calculated value.

Example: Using our previous sample data to show how it works.

Adding Apostrophe Excel 3-2

You can also show formulas in multiple sheets. For this, select the worksheets by pressing and holding the Ctrl key and clicking the worksheets, then press the Ctrl key and ~ on the keyboard. If you want to switch back to no formula shown in a worksheet, press and hold the Ctrl key and press ~ again.

Show Formulas Selected Cells Only Instead of the Results.

Example: In the below sample data, select all the cells.

Show Formulas in MS Excel 3-3

Now, click ” Find and Select “, then select Replace dialog box.

Replace dialog box Excel 3-4

  • Within the replace tab, enter “ =” in the ” Find what ” field and “ ‘=” in the ‘Replace with’ field and then click on Replace All.

Within the replace tab

  • It will show formulas in all the selected cells, while the other cells will not be changed.

Show Formulas in MS Excel 3-6

Things to Remember About Show Formula in Excel

  • Sometimes, we might witness a problem wherein we type formula, and when we press Enter, we get no result. We try again and again, but nothing happens.

The excel formulas show as text and don’t show the result. Like the cell shows :

=sum(A1, B1) but not the result.

One of the reasons could be that unknowingly you set cell formatting to Text instead of General.

This is shown below:

Show Formulas in MS Excel 3-7

Now make formatting from Text to General.

Show Formulas in MS Excel 3-8

Another reason could be, you might have pressed, or Show Formulas is enabled.

This can be fixed by pressing CTRL+` again or disable the Show Formulas button.

  • Sometimes, the presence of space character or apostrophe before the equal to sign in the formula makes the cell format like text, and the formula shows up instead of the value. To handle this, simply remove these. You can use find and replace to do this.
  • It might happen in a hurry that we press the wrong key with Ctrl instead of pressing Ctrl+`. Hence we don’t see the formula in that cell.
  • Be careful to study/check the formula by using the above methods but do not lose/delete the formulas in your worksheet/workbook.

Recommended Articles

This has been a guide to Show Formula in Excel. Here we discuss how to use Show Formula in Excel along with practical examples and a downloadable excel template. You can also go through our other suggested articles-

  1. Basic Excel Formulas 
  2. Write Formula in Excel
  3. Excel Evaluate Formula
  4. Excel Text with Formula

Primary Sidebar

Footer

Follow us!
  • EDUCBA FacebookEDUCBA TwitterEDUCBA LinkedINEDUCBA Instagram
  • EDUCBA YoutubeEDUCBA CourseraEDUCBA Udemy
APPS
EDUCBA Android AppEDUCBA iOS App
Blog
  • Blog
  • Free Tutorials
  • About us
  • Contact us
  • Log in
Courses
  • Enterprise Solutions
  • Free Courses
  • Explore Programs
  • All Courses
  • All in One Bundles
  • Sign up
Email
  • [email protected]

ISO 10004:2018 & ISO 9001:2015 Certified

© 2025 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA

Download Show Formula Excel Template

EDUCBA Login

Forgot Password?

EDUCBA

Download Show Formula Excel Template

EDUCBA

डाउनलोड Show Formula Excel Template

🚀 Limited Time Offer! - 🎁 ENROLL NOW