Show Excel Show Formula (Table of Contents)
Show Formula in ExcelShow Formulas in excel helps the user to see the formulas there in any cell of the worksheet, and it shows all the types and any length of formula. 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 in the box of Show formula in the cell. And if we see the print preview, it will show the formula instead of the value. 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 surely help to understand different ways to show formulas in Excel worksheets. Here is the sample data used for examples: We will look at a few examples to understand this better. Example #1 – Double-Clicking a Single Cell to Exhibit the Formula
Example #2 – Show Formula in Excel
This shows the formula rather than the result. Example #3 – By Enabling Show Formula in Workbook Option
This might look like a lengthy process but is very handy in case you want to show the formula for multiple sheets.
Example #4 – Keyboard Shortcut to see the Formula of a WorkbookThe 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. 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. In case you want to switch back to no formula shown in a worksheet, press and hold the Ctrl key and press ~ again. You can also show formulas in multiple sheets. For this, first select the worksheets by pressing and holding the Ctrl key and clicking the worksheets, then press the Ctrl key and ~ on the keyboard. Show Formulas Selected Cells Only Instead of the Results. Example: In the below sample data, select all the cells. Now, click ” Find and Select “, then select Replace dialog box.
Things to Remember About Show Formula in Excel
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: Now make formatting from Text to General. 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.
Recommended ArticlesThis 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- |