- 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 which shows formulas:
This allows you to easily view formulas at a glance. The formulas can also be printed and verified.