How To Display Formulas In Excel

To display formulas in Excel, select the cells containing the formulas and press the ‘Ctrl + ` (grave accent)’ key combination.

How To Display Formulas In Excel: Step-by-Step


Step 1: Open Excel Spreadsheet,

After launching Microsoft Excel, locate and open the specific spreadsheet that contains the desired formulas you wish to display.

Next Step

Step 2: Select Cells,

To reveal the formulas in a spreadsheet, simply click and drag your mouse to select the desired cells. Alternatively, use “Ctrl + A” to select all cells and display all formulas at once.

Next Step

Step 3: Open the Formula Auditing Toolbar,

To access the formula auditing toolbar in Excel, simply click on the “Formulas” tab located on the Ribbon interface. This will enable you to perform various debugging and analysis functions.

Next Step

Step 4: Show Formulas,

In the Formula Auditing section, click “Show Formulas” to display formulas instead of results for all selected cells or the entire worksheet.

Next Step

Step 5: Toggle Between Formula and Result,

By pressing the “Show Formulas” button again, you can switch back to viewing the results of the formulas instead of the formulas themselves. This button acts as a toggle between the formulas and their results.

Next Step

Step 6: Adjust Column Width If Necessary,

Showing complex formulas may lead to wider cells. Adjust column width accordingly to display all formulas clearly.


Displaying formulas in Excel is a simple yet powerful technique that can greatly enhance your data analysis and visualization. By understanding the various methods and options available, you now have the ability to showcase the underlying calculations within your spreadsheets. Whether you prefer using the dedicated formula bar, the Show Formulas feature, or a combination of both, you can easily toggle between formula and result views to ensure accuracy and validate results. Remember, displaying formulas not only improves transparency and collaboration but also empowers you to easily troubleshoot errors and make informed decisions. So, go ahead and unleash the full potential of Excel to effectively communicate your data-driven insights using formulas at your fingertips.

Table of Contents