How to Show Formulas in Excel

By showing formulas in Excel, you can quickly check for inaccuracies and make the changes needed. It can also help you find the cells that contain certain formulas, as well as track the data.

Instructions

Difficulty: Easy

Things You’ll Need:

• Computer
• Microsoft Excel

1. Turn on your computer and open Excel. Find the spreadsheet in which you wish to show the formulas.
2. The easiest way to show formulas in Excel is to press the Control and the grave accent keys. The grave accent key is to the left of the number one and looks like this: ( ` ). All formulas on the spreadsheet should now be displayed.
3. To hide the formulas on the spreadsheet, simply press the Control and grave accent keys again.

Who Can Help:

• Find Computer, Electrical and Telephone Services Here. Compare Up to 4 Quotes, Free Service & No Obligation.
• Find Electrical Services Here. Compare Up to 4 Quotes, Free Service & No Obligation.