Microsoft KB Archive/25918

Viewing Values, Not Formulas, on an Excel Macro Sheet PSS ID Number: Q25918 Article last modified on 02-26-1993 PSS database name: W_eXceL

2.00 2.01 2.10 3.00 | 2.20 2.21 3.00

WINDOWS | OS/2

Summary:

To quickly switch between displaying values and formulas for your macro sheet or worksheet, press CTRL+ACCENT MARK (`). (Note: This is not an apostrophe).

More Information:

To perform this operation with a mouse, do the following:


 * 1) From the Options menu, choose Display.
 * 2) Select the Formulas box to display formulas, clear the selection to it to display values.
 * 3) Choose OK.

To see both values and formulas at the same time, create a new window for the same sheet by performing the following steps:


 * 1) From the Window menu, choose New Window.
 * 2) From the Options menu, choose Display.
 * 3) Select or clear the Formulas box as desired.
 * 4) Choose OK.
 * 5) To view both windows, choose Arrange All from the Window menu.

Additional reference words: 2.00 2.0 2.01 2.1 2.10 2.2 2.21 2.20 3.00 3.0

Copyright Microsoft Corporation 1993.