absolute reference shortcut mac excel 2013

How to Show Formulas in Excel Instead of Calculated Values

When working with formulas in Microsoft Excel, it's common to want to see the calculations behind the scenes. Sometimes, you may need to troubleshoot a formula or understand how a calculation is being performed. In this tutorial, we will explore how to show formulas in Excel instead of the calculated values.

Using the Show Formulas Option

To start, navigate to the Formula Auditing group and click on the 'Show Formulas' option. This toggle button allows you to quickly switch between viewing formulas and their calculated results. Clicking on it again will return the display to showing the calculated values.

Showing Formulas in Excel

Once you've clicked on the 'Show Formulas' option, all formulas in your worksheet will become visible. You can see the actual formulas instead of the calculated values. This feature is useful when you need to review or modify a formula.

Using the Formulas Tab

Another way to access this functionality is by clicking on the 'Formulas' tab in the ribbon. From here, you can toggle the 'Show Formulas' option on and off as needed.

Showing Formulas in Selected Cells Only

If you only want to show formulas for a specific range of cells, you can select those cells and then click on the 'Show Formulas' option. This will display only the formulas within that selected range.

In this tutorial, we covered how to show formulas in Excel instead of calculated values. By using the 'Show Formulas' option or the 'Formulas' tab, you can easily toggle between viewing formulas and their results. Whether you need to troubleshoot a formula or understand how a calculation is being performed, showing formulas in Excel can be a helpful tool.

Absolute reference shortcut mac excel 2013