Show All Formulas in a Worksheet in Excel

Add to Favorites
Author:

Display all formulas instead of their output values.

This allows you to quickly troubleshoot issues in a worksheet without having to select each cell individually.

Go to the Formulas tab and click the Show Formulas button:

Now, your worksheet will look like this:

As you can see, this lets you quickly see what formulas and functions are contained within each cell.  This helps you troubleshoot because most formulas in Excel follow a pattern, as you can see with those in Column E and so errors often stand-out.

Also, now, if you just select a cell, all cells used in the current cell's formula will be highlighted:

You can use the arrow keys to quickly move between cells to see how this can be helpful.

To go back to normal, just click the Show Formulas button again.

Notes

Download the accompanying workbook for this tutorial to see this example in Excel.


Downloadable Files: Excel File

Question? Ask it in our Excel Forum


Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Similar Content on TeachExcel
Highlight, Sort, and Group the Top and Bottom Performers in a List in Excel
Tutorial: How to highlight the rows of the top and bottom performers in a list of data. This allows...
Quickly Move Cells Around a worksheet in Excel Cut/Paste Trick
Tutorial: Moving Cells around a worksheet in Excel is fast an easy. Below I have a table of forename...
Loop through a Range of Cells in a UDF in Excel
Tutorial: How to loop through a range of cells in a UDF, User Defined Function, in Excel. This is ...
Best Lookup Formula in Excel - Index and Match
Tutorial: A lookup using INDEX and MATCH is like a VLOOKUP without the restrictions.  Index and Ma...
Option Buttons with Formulas in Excel
Tutorial: How to make Excel option buttons in a worksheet that are linked to formulas and functions...
Print Preview Display for Specific Worksheets in Excel
Macro: This free Excel macro allows you to display the print preview mode or window in Excel for ...
Tutorial Details
Downloadable Files: Excel File
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course