Data Conversion

ExcelTips Daily Nuggets

Excel allows you to configure what happens when you press Enter in a cell. This change, which controls the direction in which the following cell is selected, is applicable to all instances of Excel you use from that time forward. You may want to vary, on a workbook by workbook basis, how the Enter key behaves. This tip explains how this can be done. ((This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.).) Read this ExcelTip: Choosing Direction After Enter On a Workbook Basis Microsoft Excel Tips - Learn Excel Faster!

The AutoFormat tool can save a great deal of time when formatting tables of data. This tip explains how to use the tool to get the best results for your data. ((This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.).) Read this ExcelTip: Using AutoFormat Microsoft Excel Tips - Learn Excel Faster!

The custom dictionary used in Excel contains the information you decide relative to spelling. After a while, you might start to realize how much work it took to get that dictionary just as you like it. Here's how to back up all that work. ((This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Excel 2003, and Excel 2007.).) Read this ExcelTip: Backing Up Custom Dictionaries Microsoft Excel Tips - Learn Excel Faster!

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. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.) Read this ExcelTip: Copying Worksheets in a Macro Microsoft Excel Tips - Master Excel's Power!

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. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.) Read this ExcelTip: Getting a File Name Microsoft Excel Tips - Master Excel's Power!

When working with charts and chart objects, Excel is very dependent on the mouse. If you don't want to use the mouse, but instead want to use the keyboard, the techniques to apply are not immediately evident. This tip explains how to select and resize a chart object in a worksheet, using nothing but the keyboard. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.) Read this ExcelTip: Using the Keyboard to Select and Resize a Chart Object Microsoft Excel Tips - Master Excel's Power!

Excel allows the headings of a workbook to be centered across several columns. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.) Read this ExcelTip: Centering Across Columns Microsoft Excel Tips - Master Excel's Power!

Selecting all the formulas in a worksheet is easy, if you know how. All you need to do is display the Go To Special dialog box and specify you want all of the formulas selected—quick and simple! (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.) Read this ExcelTip: Selecting Formulas Microsoft Excel Tips - Master Excel's Power!

Scenarios that you define are not static; you can easily change them to reflect different assumptions or to contain updated values. This tip explains how to edit an existing scenario without affecting anything shown in the workbook. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.) Read this ExcelTip: Editing a Scenario Microsoft Excel Tips - Master Excel's Power!

Microsoft Word allows you to set up all sorts of tab stops, including decimal tabs. Excel provides no way for you to do this same type of formatting, but there are ways to approximate decimal tab stops. This tip discusses some techniques you can use. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.) Read this ExcelTip: Decimal Tab Alignment Microsoft Excel Tips - Master Excel's Power!