XL2002: Articles About New Formatting Features in Excel 2002 (293449)


The information in this article applies to:

  • Microsoft Excel 2002
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 "Find and Replace" 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

REFERENCES

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.
Modification Type:MajorLast Reviewed:3/22/2002
Keywords:kbhowto KB293449
©2002 Microsoft Corporation. All rights reserved.