Microsoft Office Tutorials and References

In Depth Information

Figure 22-8:
Zooming out and selecting all formula cells can give you a good overview of how the worksheet is

designed.

Viewing formulas

You can often understand an unfamiliar workbook by displaying the formulas rather than the results of the for-

mulas. To toggle the display of formulas, choose Formulas
⇒
Formula Auditing
⇒
Show Formulas. You may want

to create a second window for the workbook before issuing this command. This way, you can see the formulas

in one window and the results of the formula in the other window. Choose View
⇒
Window
⇒
New Window to

open a new window.