Excel allows you to quickly select all the formulas in a worksheet. You may want to do this in preparation for applying formatting, or for some other purpose. To select all your formulas, follow these steps:
- Press F5. Excel displays the Go To dialog box.
- Click on Special. Excel displays the Go To Special dialog box. (See Figure 1.)
- Choose the Formulas radio button.
- Using the four check boxes under the Formulas radio button, indicate the type of results that should be produced by the formulas you want selected.
- Click on OK.
Figure 1. The Go To Special dialog box.