Article ID: 293449 - Last Review: January 31, 2007 - Revision: 1.2

XL2002: Articles About New Formatting Features in Excel 2002

View products that this article applies to.

This article was previously published under Q293449

SUMMARY

Microsoft Excel 2002 offers several new formatting options for workbook and worksheet formatting:

Color-coded worksheet tabs.
Smart Tags
Unmerge Cells button on the toolbar.
Retain column widths option.
Border drawing tools.

This article lists frequently asked questions and troubleshooting topics for some of the new formatting features in Excel 2002.

Back to the top

MORE INFORMATION

For more information, click the article numbers below to view the articles in the Microsoft Knowledge Base.

General Topics

1. How do I make the paste options button disappear?

289577 (http://support.microsoft.com/kb/289577/EN-US/ ) HOW TO: Make Paste Options Disappear After You Paste in Excel 2002

2. How can I change the available sheet tab colors?

288412 (http://support.microsoft.com/kb/288412/EN-US/ ) XL2002: How to Change the Color Palette for Workbooks

3. How do I use the new border drawing tools?

288852 (http://support.microsoft.com/kb/288852/EN-US/ ) XL2002: How to Use Draw Border and Draw Border Grid to Apply and Remove Cell Borders

4. How do I use Smart Tags?

289148 (http://support.microsoft.com/kb/289148/EN-US/ ) XL2002: Smart Tag Functionality

5. How do I use the new Find and Replace dialog box?

288291 (http://support.microsoft.com/kb/288291/EN-US/ ) XL2002: How to Use New "Find and Replace" Dialog Box in Excel 2002

6. How do I add an image to the header or footer?

288964 (http://support.microsoft.com/kb/288964/EN-US/ ) XL2002: How to Add an Image to a Worksheet's Header or Footer

Troubleshooting Help

1. Why can I only look up cells if the formatting is exactly the same?

283626 (http://support.microsoft.com/kb/283626/EN-US/ ) XL2002: Can Only Find Exact Matches When You Find Formats Based on a Cell

2. Why does the color palette look different?

291293 (http://support.microsoft.com/kb/291293/EN-US/ ) XL2002: Color Palette Looks Different in Microsoft Excel 2002

3. Why do my header/footer graphics run onto the page?

288966 (http://support.microsoft.com/kb/288966/EN-US/ ) XL2002: Graphics in Header or Footer Extend into Data Area of Worksheet

Back to the top

For more information about any of the formatting features listed in this article, click Microsoft Excel Help on the Help menu, type the feature name (such as Smart Tags) in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.

Back to the top