Microsoft KB Archive/43936

{| = Excel: Keyboard Shortcuts for Displaying Formulas =
 * width="100%"|

Last reviewed: October 31, 1994

Article ID: Q43936

SUMMARY
In Microsoft Excel versions 1.50 and earlier, typing the letter &quot;F&quot; with the Options Display dialog active toggles between checking and unchecking the option to display formulas. In Excel version 2.20, pressing the letter &quot;R&quot; with the Options Display dialog active has the same effect of toggling the option to display formulas.

&quot;R&quot; was chosen as the toggle key in version 2.20 rather than &quot;F&quot; in order to remain consistent with the selection of &quot;R&quot; to pull down the Formula menu. &quot;R&quot; was chosen to pull down the Formula menu because &quot;F&quot; is already used to pull down the File menu.

Since &quot;R&quot; is the toggle key for the display of formulas, &quot;H&quot; is used as the toggle key to display row and column headings.

An even quicker way to toggle a worksheet between showing values and showing formulas in Excel 2.20 is to hold down the COMMAND key and press the back apostrophe key (`, or unshifted tilde). This method allows you to toggle the display of formulas in a worksheet without having to select any dialog boxes.

KBSubcategory: kbother KBSubcategory:
 * }