Tips.Net > ExcelTips Home > Editing > Selecting Formulas
Selecting Formulas
Summary: Selecting all the formulas in a worksheet is easy, if you know how. All you need to do is display the Go To Special dialog box and specify you want all of the formulas selected—quick and simple! (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.)
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, press Ctrl+G, or choose Go To from the Edit menu. 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.
Tip #2741 applies to Microsoft Excel versions: 97 2000 2002 2003
Save Time and Money! Many people need to keep track of employee time, but don't know where to start when it comes to creating a spreadsheet. Here's a way to save time, effort, and money with ready-to-use timesheet templates.
Check out Timesheet Templates today!
Perplexed by Pivots?
PivotTables don't need to be scary or mysterious. Use this powerful tool to analyze your data in ways you didn't know were possible. (more information...)
Helpful Links
Ask an Excel Question
Make a Comment
ExcelTips FAQ
ExcelTips Premium
Beauty Tips
Bugs and Pests Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Organizing Tips
Pet Tips
Word2007 Tips
WordTips
Advertise on the
ExcelTips Site