The worksheet will now display with formulas instead of values.
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 Ways)ĭ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 February 25, 2020Īpplies to: Microsoft ® Excel ® 2010, 2013, 2016, 2019 and 365 (Windows)
