Sams Teach Yourself Microsoft Office 2003 in 24 Hours

By Greg Perry

• Table of Contents
  • Copyright
  • About the Author
  • Acknowledgments
  • We Want to Hear from You!
  • Introduction
  • Who Should Read This Book?
  • What This Book Does for You
  • Can This Book Really Teach Office 2003 in 24 Hours?
  • Conventions Used in This Book
  • Part I. Working with Office 2003
  • Hour 1. Getting Acquainted with Office 2003
  • Part II. Processing with Word 2003
  • Hour 2. Welcome to Word 2003
  • Hour 3. Formatting with Word 2003
  • Hour 4. Managing Documents and Customizing Word 2003
  • Hour 5. Advanced Word 2003
  • Part III. Computing with Excel 2003
  • Hour 6. Understanding Excel 2003 Workbooks
  • Hour 7. Restructuring and Editing Excel 2003 Worksheets
  • Hour 8. Using Excel 2003
  • Hour 9. Formatting Worksheets to Look Great
    • AutoFormatting Worksheets
    • Modifying Styles
    • Additional Formatting Options
    • Conditional Formatting
    • Separating Worksheets with Tab Colors
    • Summary
    • Q&A
  • Hour 10. Charting with Excel 2003
  • Part IV. Presenting with Flair
  • Hour 11. PowerPoint 2003 Presentations
  • Hour 12. Editing and Arranging Your Presentations
  • Hour 13. PowerPoint 2003 Advanced Features
  • Hour 14. Animating Your Presentations
  • Part V. Organizing with Outlook 2003
  • Hour 15. Communicating with Outlook 2003
  • Hour 16. Planning and Scheduling with Outlook 2003
  • Part VI. Tracking with Access 2003
  • Hour 17. Access 2003 Basics
  • Hour 18. Entering and Displaying Access 2003 Data
  • Hour 19. Retrieving Your Data
  • Hour 20. Reporting with Access 2003
  • Part VII. Combining Office 2003 and the Internet
  • Hour 21. Office 2003 and the Internet
  • Hour 22. Creating Web Content with Word, Excel, Access, and PowerPoint
  • Part VIII. Publishing Eye-Catching Documents
  • Hour 23. Publishing with Flair Using Publisher 2003
  • Hour 24. Adding Art to Your Publications
  • Part IX. Appendixes
  • Appendix B. Business Contact Manager and Office Extras
  • Part X. Bonus Hours
  • Hour 25. Using FrontPage 2003 for Web Page Design and Creation
  • Hour 26. Managing Your Web with FrontPage

Modifying Styles

Suppose that you often print worksheets to fax to others, and your fax requires boldfaced worksheets so that the recipients can read the numbers. Instead of changing your worksheet text to boldface before faxing the worksheet, you can make boldface the default font style. Excel enables you to change several of the font defaults. So if you find yourself applying the same font style over and over, consider making that style part of Excel's default style.

To Do: Modify the Default Style

To modify the default style, follow these steps:

1. Select Format, Style to display the Style dialog box, as shown in Figure 9.3.
   

   Figure 9.3 You can change any named style.

2. Select the default style, Normal, from the Style Name drop-down list box. (The Normal style is probably already the style you see when you open the dialog box.)
3. To change the Normal style, click the Modify button. Excel displays the Format Cells dialog box, as shown in Figure 9.4, from which you can modify the named style.
   

   Figure 9.4 The Format Cells dialog box allows you to modify any format currently set.

4. Indicate the changes you want to make to the style in the Format Cells dialog box. When you're finished, click OK to close the Format Cells dialog box.
5. Click OK to close the Style dialog box. Excel applies your style to the selected cells. If you made changes to the Normal style, Excel automatically uses that format on future worksheets unless you modify the format or style.

Share This