There is one more method that you can use if you want to really hide formulas and prevent others from unhiding them. So in D2, the formula would be =FORMULATEXT(C2). In the following example, we have regular formulas in column C and in column D, we've used the FORMULATEXT function: The formula refers to another workbook but the workbook is not open.The formula refers to a cell that does not contain a formula.The FORMULATEXT function will return an #N/A error if: The syntax for the FORMULATEXT function is =FORMULATEXT(reference) where reference is a cell or a range of cells. The FORMULATEXT function is available in Excel 2013 and later versions. This is very useful if you want to audit a worksheet and view both values and formulas. You can also use the FORMULATEXT function in a cell to display the formula from another cell as a text string. Showing formulas using the FORMULATEXT function Click Show Formulas again to hide the formulas.The worksheet will now display with formulas instead of values.

In the Formula Auditing group, click Show Formulas.Showing formulas using a buttonĪn easy way to show or hide formulas in Excel is to use the Show Formulas button. The tilde / accent grave key appears on the top left of most keyboards below the Esc key. This shortcut works in all versions of Excel. Press Ctrl + tilde (~) or Ctrl + accent grave (`) to show or hide formulas. You can show or hide formulas using a keyboard shortcut. Recommended article: How to Delete Blank Rows in Excel (5 Fast Ways to Remove Empty Rows)ĭo you want to learn more about Excel? Check out our virtual classroom or live classroom Excel courses > Showing formulas using a keyboard shortcut With the third method, you can view formulas for specific cells. Although you can double-click a cell or press F2 to show the formula in one cell, the first two methods will show formulas in all cells. You can use a keyboard shortcut, click a button and even use a formula to show formulas. You can easily show or hide formulas in a number of ways in Microsoft Excel. Show or Hide Formulas in Excel Using a Keyboard Shortcut, Button or Formulaīy Avantix Learning Team | Updated March 7, 2022Īpplies to: Microsoft ® Excel ® 2010, 2013, 2016, 2019, 2021 and 365 (Windows)

Excel shortcut keys display formula