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)
