How to Show Formulas in Excel

Intellezy Trainers
A free video tutorial from Intellezy Trainers
Computer Training Specialists
4.4 instructor rating • 198 courses • 150,441 students

Learn more from the full course

Excel 2016 Advanced

Take Excel to the next level with advanced formulas, What-If Analysis tools, advanced PivotTables, Macros and much more

02:18:13 of on-demand video • Updated April 2018

  • Use Advanced IF Statements
  • Use Advanced Lookup Functions
  • Use Complex Logical and Text Functions
  • Auditing Formulas
  • Working with What-If Analysis Tools
  • Protecting Worksheet and Workbook
  • Use Advanced PivotTables and PowerPivot Tools
  • Automate with Macros
  • Work with Form Controls
  • Ensure Data Integrity
  • Collaborate in Excel
  • Import and Export Data to a Text File
English -: Let's take a look at some of the formula auditing tools, starting with how you can show formulas. You might want to be able to see every single cell in your worksheet that has a formula in it, rather than having to click on each individual cell and looking in the formula bar. Two ways we could do this, alright, very simple. One is, I'm going to go to the Formulas tab in the ribbon. If I look over to the right here, I see Show Formulas. I can go ahead and click on that, it's going to go ahead and expand and show all my formulas in my cells. I can turn that off by clicking Show Formulas again. I can also do this using the keyboard shortcut of Control + tilde, Control + tilde, the little wavy line in the upper, left-hand corner of your keyboard. So I'm holding Control, hitting my tilde, same exact thing, I can show or I can hide my formulas.