"How to Display Formulas in Excel: Visualizing Cell Formulas for Better Understanding and Analysis"

Christopher Jun 16, 2026

Show Formulas in Excel: A Step-by-Step Guide

Top 21 Excel Formulas
Top 21 Excel Formulas

When working with complex Excel spreadsheets, it can be challenging to identify the source of errors or discrepancies. One effective way to troubleshoot and optimize your spreadsheet is to display the formulas, also known as "Formulas as Values" or "Show Formulas." In this article, we'll explore the benefits of showing formulas in Excel and provide a step-by-step guide on how to achieve this.

ms excel formula
ms excel formula

Why Show Formulas in Excel?

Displaying formulas in Excel offers several advantages, including:

Complete Excel Formula Cheat Sheet | Excel Functions, Shortcuts & Tips for Students
Complete Excel Formula Cheat Sheet | Excel Functions, Shortcuts & Tips for Students
  • Easy debugging: When a formula is not working as expected, showing formulas makes it easier to identify the source of the issue.
  • Improved understanding: By displaying the underlying formulas, you can gain a deeper understanding of how your spreadsheet behaves and make data-driven decisions.
  • Better analysis: With formulas visible, you can analyze and optimize your spreadsheet more efficiently.

How to Show Formulas in Excel

an excel chart with the number of movies in it
an excel chart with the number of movies in it

To display formulas in Excel, follow these simple steps:

1. Select the cell or range of cells that contains the formula you want to display.

2. Go to the Data tab in the Excel ribbon.

Excel Formulas: Basic to Advanced
Excel Formulas: Basic to Advanced

3. Click on the Formulas group and select Show Formulas from the dropdown menu.

4. Alternatively, you can press Ctrl+~ to toggle on or off the show formulas option.

Shortcuts and Keyboard Navigation

the top 15 excel formulas are written on lined paper with different symbols and numbers
the top 15 excel formulas are written on lined paper with different symbols and numbers

Excel provides several shortcuts to help you work more efficiently:

  • Ctrl+~: Toggle to show or hide formulas.
  • Alt+P+U: Toggle to show formulas and values.
Exel Formulas
Exel Formulas
How to Use Excel Functions in Formulas - TheAppTimes
How to Use Excel Functions in Formulas - TheAppTimes
Excel Formula Cheat Sheet Printable - Excel Functions Guide PDF - Excel Reference Sheet Digital Download
Excel Formula Cheat Sheet Printable - Excel Functions Guide PDF - Excel Reference Sheet Digital Download
Top Excel Formulas Cheat Sheet for Students
Top Excel Formulas Cheat Sheet for Students
How to show formula bar in Excel
How to show formula bar in Excel
Excel Formulas You Should Know
Excel Formulas You Should Know
3 Crazy Microsoft Excel Formulas That Are Extremely Useful
3 Crazy Microsoft Excel Formulas That Are Extremely Useful
Excel Sum Formula Examples, Excel Sum Formula Guide, Excel Spreadsheet Learning, Excel For Business Data Management, Excel Spreadsheet Formulas, Excel For Business Management, How To Assign Serial Numbers In Excel, Excel Spreadsheet Skills, Excel Sumproduct Guide
Excel Sum Formula Examples, Excel Sum Formula Guide, Excel Spreadsheet Learning, Excel For Business Data Management, Excel Spreadsheet Formulas, Excel For Business Management, How To Assign Serial Numbers In Excel, Excel Spreadsheet Skills, Excel Sumproduct Guide
the top 30 excel formulas for data and texting are shown in this poster
the top 30 excel formulas for data and texting are shown in this poster
How to Use Forecast Formula in Excel
How to Use Forecast Formula in Excel
What Is the $ Symbol in Excel (Excel Formulas)?
What Is the $ Symbol in Excel (Excel Formulas)?
SWITCH Formula in Excel
SWITCH Formula in Excel
How to show Formulas in Excel Instead of the Values
How to show Formulas in Excel Instead of the Values
a notebook with the words most used maths excel formulas
a notebook with the words most used maths excel formulas
Excel Formulas
Excel Formulas
How to Copy a Formula Down in Excel Using the Fill Handle
How to Copy a Formula Down in Excel Using the Fill Handle
the basic excel formats and numbers for each type of document, including two columns
the basic excel formats and numbers for each type of document, including two columns
Basic Excel Formulas! 👍💯
Basic Excel Formulas! 👍💯
Excel Formula Guide for Office & MIS Work
Excel Formula Guide for Office & MIS Work
Excel formulas
Excel formulas

Working with Large Spreadsheets

When working with large Excel spreadsheets, displaying formulas can help you identify performance bottlenecks. To optimize your spreadsheet's performance, consider the following tips:

1. Limit the number of formulas: Avoid using excessive formulas, as they can slow down your spreadsheet.

2. Simplify formulas: Use more efficient formulas and avoid unnecessary calculations.

3. Use array formulas judiciously: Array formulas can improve performance, but they can also slow down your spreadsheet if misused.

Conclusion (Sort of...

Displaying formulas in Excel is a simple yet powerful technique that helps you troubleshoot, optimize, and understand your spreadsheet. By following the steps outlined in this article, you'll be able to quickly show formulas and gain insights into your spreadsheet's workings. Whether you're a seasoned Excel user or a beginner, display formulas are an essential tool to have in your spreadsheet toolkit.

Additional Resources

For more information on Excel formulas and best practices, check out these additional resources: