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:

• Using Find and Replace to Pre-Pend Characters. Need to add some characters to the beginning of the contents in a range of cells? It's not as easy as you might hope, but here are some great ideas. (January 3, 2009)
• Turning Off Automatic Backups in Excel 2007. Excel can make backups whenever you save your workbook. If you want to turn off the feature, you might wonder where the control is located. Here's how to find it. (January 3, 2009)
• Protecting Excel Files from Word. Office easily allows you to use Word to open an Excel document. Doing so, however, can quickly result in and unusable workbook. Here's how to protect your data. (January 3, 2009)
• Naming Tabs for Weeks. Need to set up a workbook that includes a worksheet for each week of the year? Here's a couple of quick macros that can do the hard work for you. (January 3, 2009)

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)

An Amazing Resource!

Thousands of ExcelTips, available for immediate download. Have all the Microsoft Excel info you need, right at your fingertips. (more information...)

Great Info!