Data Conversion

ExcelTips Daily Nuggets

When you make a change to one of Excel's toolbars, do you know where that change is stored? This tip explains the name and characteristics of the special file in which the customization is stored. Armed with this information you can transfer the customizations between systems and you can protect against loss of the information. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.) Read this ExcelTip: Where is Toolbar Customization Information Stored? Microsoft Excel Tips - Master Excel's Power!

Excel includes the ability to reduce a printout so that it fits on a desired number of pages. This tip explains the scaling feature, and provides a way you can make sure that your printout is never more than a single page wide. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.) Read this ExcelTip: Scaling Your Printing Microsoft Excel Tips - Master Excel's Power!

The header and footer capabilities of Excel are not that great. For instance, you cannot instruct Excel to print one footer on the first page of a printout and a different footer on subsequent pages. The way around this limitation is to use a macro to handle the footers and printing. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.) Read this ExcelTip: Using a Different Footer on Secondary Pages Microsoft Excel Tips - Master Excel's Power!

This VBA macro will sort all of the worksheets in a workbook by worksheet name. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.) Read this ExcelTip: Sorting Worksheets Microsoft Excel Tips - Master Excel's Power!

You can use AutoFilter to change what is displayed on the screen. If you want to count the records displayed by an AutoFilter, there are a couple of ways you can do it. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.) Read this ExcelTip: Counting Displayed Cells Microsoft Excel Tips - Master Excel's Power!

Conditional formatting is a powerful feature of Excel. You cannot directly sort or filter based on the results of this special type of formatting, however. Using the results of a conditional formatting test can be achieved, but the easiest way is to change the structure of your worksheet. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.) Read this ExcelTip: Sorting or Filtering by Conditional Format Results Microsoft Excel Tips - Master Excel's Power!

Don't need that old macro any more? Here's how to get rid of it so that it is no longer a part of your workbook. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.) Read this ExcelTip: Deleting a Macro Microsoft Excel Tips - Master Excel's Power!

Some people want a formula to return a blank value based upon a calculation or comparison. Such a condition is impossible in Excel—formulas can never return blank values. (In fact "blank value" could be considered an oxymoron, as any value is, by definition, non-blank.) This tip explains the details of such statements. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.) Read this ExcelTip: Returning a Blank Value Microsoft Excel Tips - Master Excel's Power!

Excel makes it very easy to insert a column or row in a worksheet. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.) Read this ExcelTip: Inserting a Row or Column Microsoft Excel Tips - Master Excel's Power!

The Select Case programming structure allows you to create a framework of conditional code that will be executed only under the conditions you specify. This tip explains how to build your Select Case structure. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.) Read this ExcelTip: Understanding the Select Case Structure Microsoft Excel Tips - Master Excel's Power!