Add-Ins [23]

Charts [23]

Conditional Formatting [24]

Customizing Excel [47]

Custom Views [7]

Data Entry [66]

Data Validation [13]

Editing [125]

Excel's Environment and Interface [11]

Files [76]

Filtering [19]

Find and Replace [8]

Formatting [154]

Formulas [138]

General [110]

Graphics [101]

Macros [324]

Online and Web [44]

Page Setup [50]

PivotTables [13]

Printing [77]

Shortcut Keys [7]

Sorting [24]

Subtotals [7]

Tools [95]

Workbooks [39]

Working with Other Programs [13]

Worksheet Functions [103]

Worksheets [48]

Newest/Updated ExcelTips

These are the newest ExcelTips or ExcelTips that have been recently updated:

• Generating Double-Digit Random Numbers. Normally you use the RAND and RANDBETWEEN functions to generate random numbers. What if you want to generate random numbers within a certain range but exclude some numbers in that range? Here's some ideas on how to get what you want. (May 3, 2008)
• Converting Time Notation to Decimal Notation. Want to convert an elapsed time, such as 8:37, to a decimal time, such as 8.62? If you know how Excel stores times internally, coming up with the conversion formula is a snap. (May 3, 2008)
• Excluding Values from Averaging. Calculating an average of a group of numbers is easy. What if you want to exclude a couple of the numbers from the group you are averaging? Here's the tools you need to develop a formula that will give you what you want. (May 3, 2008)
• Default Worksheet when Opening. When opening a workbook, you may want to make sure that a particular worksheet is always displayed first. The only way to ensure this is through the use of a macro, described here. (May 3, 2008)

Top Ten ExcelTips

These are the ten most popular ExcelTips during the past week:

1. Displaying a Hidden First Row
2. Handling Leading Zeros in CSV Files
3. Calculating Months of Tenure
4. Using Dynamic Chart Titles
5. Extracting URLs from Hyperlinks
6. Working with Elapsed Time
7. Precision and Number Display
8. Short-Lived Book1
9. References to Hyperlinks Aren't Hyperlinks
10. Creating Add-Ins

Latest Daily Nuggets

These are the latest ExcelTips Daily Nuggets. These are sent out every morning to those who subscribe to this free service. (Click here to subscribe to ExcelTips Daily Nuggets.)

• Copying Worksheets in a Macro. Do you need to write a macro that copies worksheets from one workbook to another, or even within the same workbook? If so, you need to become familiar with the Copy method, described in this tip. There are wide number of ways you can use the method to perform a copy just as you want. (February 21, 2008)
• Getting a File Name. When creating a macro, you can access the standard Open dialog box so that a user can select a file to process. This tip explains how to do that and grab the selected file name from the dialog box. (February 20, 2008)

Macros Rock!

Want to make Excel do even more? The way is easy when you know how to use macros. This great e-book makes it easy. (more information...)

Great Info!