Summary  
Techniques for toggling between formula results and their underlying expressions, and selecting and highlighting cells that contain formulas to facilitate debugging.  

General domain of usage  
Spreadsheet auditing

Understanding how to **display** and **highlight** formulas is essential for ensuring accuracy and efficiency in your work. 

Task Template

Download Solution workbook

- To display formulas, go to the **Formulas** tab → **Formula Auditing** group → **Show Formulas**;
- Highlight cells containing formulas using **Find & Select** on the **Home** tab → **Editing** group;
- Use **Go To Special** via the **Home** tab → **Editing** group to select cells that contain formulas.


Dive into the world of Excel with this comprehensive video course, designed to take you from basic navigation to mastering functions and basic data analysis. Starting with foundational skills like data entry and cell formatting, you'll quickly progress to using powerful tools. Whether you're organizing large datasets, performing statistical analysis, or creating dynamic charts, this course equips you with the practical skills needed in today’s data-driven environment.

Displaying and Highlighting Excel Formulas

Key Points

Essential Keyboard Shortcut