How to Show and Hide Formulas in Excel Easily

TL;DR

To show formulas in Excel, use Ctrl + ` (tilde) for a quick toggle, or go to the Formulas tab and click 'Show Formulas'. For a more detailed method, navigate to File > Options > Advanced and select 'Show formulas in cells instead of their calculated results'. Adjust column widths if needed to view all formulas clearly.

Transcript

in this lesson we're going to talk about how to show the formulas on an excel spreadsheet so right now you can't really see the formulas listed however if you highlight a certain cell like this one cell d3 you could see the formula at the top and it says equal b3 plus c3 so it's addition here you could see a subtraction based formula and for this o... Read More

Key Insights

• 👻 Highlighting specific cells allows you to view the formula at the top of the spreadsheet.
• ♿ The option to show formulas can be accessed through File > Options > Advanced.
• 🍰 The Formulas tab provides a shorter method to display all formulas on the spreadsheet.
• 🛀 Adjusting column widths may be necessary after showing formulas.

Questions & Answers

Q: How can I view the formulas of specific cells in an Excel spreadsheet?

To view formulas for specific cells, highlight the desired cell, and the formula will appear at the top of the spreadsheet.

Q: How do I display all formulas on an Excel spreadsheet?

There are two ways to show all formulas. The first is to go to File > Options > Advanced and select "Show formulas in cells instead of their calculated results." The second method is to click on the Formulas tab and select "Show formulas."

Q: How can I readjust column widths after displaying formulas?

To readjust column widths after displaying formulas, click the triangle button at the top left to select all cells. Then double-click the vertical line to automatically adjust the width of cells.

Q: What is the keyboard shortcut to show formulas in Excel?

The keyboard shortcut to show formulas in Excel is "Ctrl + ~" (tilde).

Summary & Key Takeaways

• By highlighting specific cells, you can see the formulas at the top of the spreadsheet.

• The first method to show all formulas is to go to File > Options > Advanced and select "Show formulas in cells instead of their calculated results."

• Another shorter method is to go to the Formulas tab and click on "Show formulas," adjusting column widths if necessary.