Shortcut for Viewing Formulas

You probably already know how to display the formulas in cells rather than the results of those formulas, right? If you're like most people, you choose Tools | Options, then on the View tab make sure the Formulas check box is selected. The process is even longer in Excel 2007—click the Office button | Excel Options | Advanced | Display Options for this Worksheet group | Show Formulas in Cells Instead of their Calculated Result check box.

A much faster way to get the same result is to press Ctrl+`. (That's hold down the Ctrl key while you press the accent grave, which is the backwards apostrophe just to the left of the 1 key and above the Tab key.) The shortcut is a toggle, which means that you can press it repeatedly to switch between the display of formulas and results.