Add-Ins [23]

Charts [25]

Conditional Formatting [25]

Customizing Excel [49]

Custom Views [7]

Data Entry [69]

Data Validation [14]

Editing [130]

Excel's Environment and Interface [11]

Files [78]

Filtering [20]

Find and Replace [8]

Formatting [159]

Formulas [148]

General [115]

Graphics [105]

Macros [328]

Online and Web [49]

Page Setup [50]

PivotTables [14]

Printing [81]

Shortcut Keys [7]

Sorting [24]

Subtotals [7]

Tools [101]

Workbooks [40]

Working with Other Programs [14]

Worksheet Functions [105]

Worksheets [53]

Newest/Updated ExcelTips

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

• Making Column Headers Vertically Wider. The header and column labels that appear on a worksheet are a very important part of working with Excel. If your column headers are smaller than you want them to be, it could be because of a font setting in Excel. (November 29, 2008)
• Condensing Sequential Values to a Single Row. If you have a bunch of ZIP Codes or part numbers in a list, you may want to "condense" the list so that sequential series of numbers are shown as a range. There are a number of ways this can be accomplished. (November 29, 2008)
• Using Your Own File Extensions. Don't like the workbook file extensions used by Excel? You can specify your own extensions, as discussed in this tip. (November 29, 2008)
• Forcing Stubborn Recalculation. Have you ever recalculated a worksheet, only to notice that not everything calculated as it should? Here's a way you can force a complete recalc, along with some ideas on why you might not be seeing the results that you expect. (November 29, 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)

Problems with Dates?

No, not that type of date. If you need to do any types of work with calendar dates, Excel has the tools you need. Learn how to use those tools the easy way. (more information...)

Great Info!