Excel 2003 Solution Center
how-to articles - Excel 2003
- How to troubleshoot errors when you save Excel files
Describes how to troubleshoot issues that may occur when you try to save Excel files.
- Description of the startup switches for Excel
Describes the startup switches that Excel uses. You can use these switches to control the way that Excel starts.
- How to open new file formats in earlier versions of Microsoft Office
Describes the installation requirements to open and save files that are in the Open XML Formats by using earlier versions of Excel, PowerPoint, and Word.
- How to create a dynamic defined range in an Excel worksheet
Provides a method to create a dynamic defined range that can automatically extend to include new information if you have a named range that must be extended.
- How to sum and format a range of hours, minutes, or seconds in Excel
Describes how to sum and format a range of hours, minutes, or seconds in Excel.
- How to recover data from damaged workbooks in Excel
Discusses methods that you can use to recover information from damaged Excel workbooks. Lists references that discuss these methods in more detail.
- HOW TO: Consolidate Multiple Worksheets to a Single Sheet in Excel
This step-by-step article describes how to consolidate multiple worksheets to a single sheet in Excel. You can summarize data from one or more source areas by consolidating it and creating a consolidation table. These source areas can be on the same...
- How to change the color palette for workbooks in Excel
Describes the steps that you use to change the color palette in Excel. You can use custom colors to modify the colors for many workbook elements.
- You cannot use VBA code to configure the Cap Type and Join Type properties in Excel
Describes an issue in which you cannot use VBA code to configure the Cap Type and Join Type properties for line styles in a chart in Excel.
- How to reset the last cell in Excel
Describes how to reset the last cell in Excel.
- How to use defined names to automatically update a chart range in Excel
Provides two methods for using defined names to automatically update a chart range. You can use these methods to set up a chart that can be automatically updated when you add new information to an existing chart range.
- How to use the "Insert Options" button in Excel
Describes how to use the "Insert Options" button in Excel.
- How to use the Histogram tool in Excel
Describes how to use the Histogram tool to create a histogram table in Microsoft Office Excel. This includes how to check whether the Analysis ToolPak Add-in is installed before you use the Histogram tool.
- How to use the Paste Options button in Excel
Describes the functionality of the Paste Options button in Excel. When you paste data into cells in Excel, the Paste Options button appears below the pasted selection.
- How to convert multiple rows and columns to columns and rows in Excel
Describes how to use a worksheet formula to convert data that spans multiple rows and columns to a database format (columnar). This article contains an example to show this process.
- How to delete every other row on an Excel worksheet
Provides a sample VBA macro that you can use to remove every other row in a selected range on an Excel worksheet. If you have a list of data that contains multiple columns, select only the first column of data when you run the macro.
- How to change the case of text in Excel
Describes how to use worksheet functions to modify the case of text in Excel. Provides an example.
- Floating-point arithmetic may give inaccurate results in Excel
Discusses that floating-point arithmetic may give inaccurate results in Excel.
- How to Use VLOOKUP or HLOOKUP to find an exact match
The VLOOKUP and HLOOKUP functions contain an argument called range_lookup that allows you to find an exact match to your lookup value without sorting the lookup table. Note It is not necessary to sort the lookup table if you use the range_lookup...
- How to find data in an Excel table
This step-by-step article describes how to find data in a table (or range of cells) by using various built-in functions in Microsoft Excel. You can use different formulas to get the same result. Create the Sample Worksheet This article uses a sample...
- How to use the OFFSET function in Excel
This article describes how to use the function to return the value of a cell that is a specified number of rows and columns away from a cell or range of cells that you referenced in an adjacent range.
- How to use the INDEX function to find data in a table in Excel
This article describes how to use the INDEX function to find data in a table at the intersection of a specific row and column in Microsoft Excel. There are two forms of the INDEX function, Array and Reference . The primary differences between the two...
- How to use the LOOKUP function in Excel
Discusses the syntax of the LOOKUP function in Excel. Provides two examples that show how to use the function.
- Method to determine whether a year is a leap year
Describes how to determine whether the year in a date that is used in an Excel document is a leap year.
- Description of link management and storage in Excel
In Microsoft Excel, you can link a cell in a workbook to another workbook using a formula that references the external workbook. When this link is created, it may use a relative path. With a relative link, you can move the workbooks without breaking...