Part IV: Using Advanced Excel Features
662
FIGURE 32.7Zooming out and selecting all formula cells can give you a good overview of how the worksheet is
designed.
Tip
Selecting the formula cells may also help you spot a common error: namely, a formula that has been replaced
accidentally with a value. If you find a cell that’s not selected amid a group of selected formula cells, chances
are good that the cell previously contained a formula that has been replaced by a value. n
Viewing formulas
You can become familiar with an unfamiliar workbook by displaying the formulas rather than the
results of the formulas. 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.Tip
You can also press Ctrl+` (the accent grave key, typically located above the Tab key) to toggle between
Formula view and Normal view. n