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

PivotTables Got You Perplexed? PivotTables for the Faint of Heart shows how you can start using Excel's PivotTable tool right away to spin your data into gold! You discover how easy it really is to crunch the numbers you need to crunch. Uncover the power of creating PivotTables, editing them, formatting them, customizing them, and much more.

Check out PivotTables for the Faint of Heart today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Selecting Formulas