Displaying Formulas
Normally, Excel does not display the actual formula in a cell. Instead, it displays the result of the calculation. You can view the formula by selecting the cell and looking in the Formula bar. However, if you're trying to review the formulas in a large worksheet, it might be easier if you could see them all at once (or print them). If you want to view formulas in a worksheet, follow these steps:
Open the Toolsmenu and choose Options.
Click the Viewtab.
In the Window Options area, click to select the Formulascheck box.
Click OK.
Display Formulas Quickly
You can use a keyboard shortcut to toggle between viewing formulas and viewing values. To do so, hold down the Ctrlkey and press ' (the accent key to the left of the 1 key; it ...
Get Ten Minute Guide to Excel 97 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
