Instead of displaying values, you can actually display formulas as a way of reviewing the spreadsheet. In this tip, we explain how that can be done.
You are welcome to download the workbook to practice.
Applies To: Microsoft® Excel® for Windows 2010, 2013, and 2016.
- To show all formulas in a worksheet, hold down the Ctrl key and press the ~ (tilde) key on the keyboard. You can also easily print the worksheet by holding down the Ctrl key and pressing the “P” key on the keyboard, this will take you to the print dialog box.
- To switch back to showing no formulas in a worksheet, hold down the Ctrl key and press ~ on the keyboard again.
- To show formulas in more than one worksheet in a workbook, first select the worksheets by holding down the Ctrl key, then hold down the Ctrl key and press ~ on the keyboard.
- Another way to show formulas, without using a keyboard shortcut is by selecting “Show Formulas” from the Formulas ribbon tab.
An example of a worksheet without showing formulas:
An example of a worksheet which shows formulas:
This allows you to easily view formulas at a glance. The formulas can also be printed and verified.