Selecting Formulas

Summary: Want to select only the formulas in your worksheet? It's easy to do using the Go To Special dialog box. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Excel 2003, and Excel 2007.)

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. (Click here to see a related figure.)
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.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2741) applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Step Up and Take Control! Subscribers to ExcelTips know just how valuable a resource it is. ExcelTips Premium provides twice the number of exceptional, easy-to-understand tips every week in an ad-free newsletter, as well as substantial discounts on ExcelTips archives and e-books.

Check out ExcelTips Premium today!