Help and Support
 

powered byLive Search

XL2002: Articles About New Formatting Features in Excel 2002

View products that this article applies to.
Article ID:293449
Last Review:January 31, 2007
Revision:1.2
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

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.

Back to the top

APPLIES TO
•Microsoft Excel 2002 Standard Edition

Back to the top

Keywords: 
kbhowto KB293449

Back to the top

Article Translations

 

Related Support Centers

Other Support Options

  • Need More Help?
    Contact a Support professional by Email, Online or Phone.
  • Customer Service
    For non-technical assistance with product purchases, subscriptions, online services, events, training courses, corporate sales, piracy issues, and more.
  • Newsgroups
    Pose a question to other users. Discussion groups and Forums about specific Microsoft products, technologies, and services.