Welcome toExcel.Tips.Net
Helpful Links
Tips.Net Home
ExcelTips Home
Ask an Excel Question
Make a Comment
ExcelTips FAQ
ExcelTips Premium
Beauty Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Organizing Tips
Pest Tips
Pet Tips
Wedding Tips
Word2007 Tips
WordTips
Advertise on the
ExcelTips Site
Newest Tips
Assigning a Macro to a Keyboard Combination
Hiding Rows Based on a Cell Value
Subscribe
RSS Feeds
Daily Nuggets (an ExcelTip every day)
Allen Wyatt's ExcelTips (the weekly classic)
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
Got the Time? Understanding the ins and outs of working with times and dates can be confusing. Remove the confusion--ExcelTips: Times and Dates is an invaluable resource for learning how best to work with times and dates.Check out ExcelTips: Times and Dates today!