Microsoft KB Archive/293449

= XL2002: Articles About New Formatting Features in Excel 2002 =

Article ID: 293449

Article Last Modified on 1/31/2007

-

APPLIES TO


 * Microsoft Excel 2002 Standard Edition

-



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.



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 HOW TO: Make Paste Options Disappear After You Paste in Excel 2002

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

288412 XL2002: How to Change the Color Palette for Workbooks

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

288852 XL2002: How to Use Draw Border and Draw Border Grid to Apply and Remove Cell Borders

4. How do I use Smart Tags?

289148 XL2002: Smart Tag Functionality

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

288291 XL2002: How to Use New &quot;Find and Replace&quot; Dialog Box in Excel 2002

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

288964 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 XL2002: Can Only Find Exact Matches When You Find Formats Based on a Cell

2. Why does the color palette look different?

291293 XL2002: Color Palette Looks Different in Microsoft Excel 2002

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

288966 XL2002: Graphics in Header or Footer Extend into Data Area of Worksheet

