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
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.