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
    • AutoCorrect Worksheets
    • Reviewing Cut, Copy, and Paste in Excel
    • Clearing Data
    • Speed Data Entry
    • Smarter Fills with AutoFill
    • Designing Your Own Fills
    • A Word About Printing
    • Adding Comments
    • Summary
    • Q&A
  • Hour 9. Formatting Worksheets to Look Great
  • 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

AutoCorrect Worksheets

Use AutoCorrect as you type Excel entries just as you used AutoCorrect in Word. When you type an abbreviation for an AutoCorrect entry, Excel converts that abbreviated form to the complete AutoCorrect entry for you when you press the spacebar or move the pointer to another cell.

To add AutoCorrect entries, perform the same steps that you do with Word; namely use the Tools, AutoCorrect Options menu to display the AutoCorrect dialog box and add your entries there.

Finding and Replacing Data

Like Word, Excel contains a powerful search-and-replace operation that can search your worksheet for values and replace those values if needed. Although Word users often use Word's search-and-replace, the feature gets less use in Excel. Nevertheless, the feature is extremely beneficial for worksheets. Imagine that you have a worksheet that tracks the payroll for your company, and the minimum wage increases. Instead of laboriously changing each and every cell that includes the minimum wage, you can use Excel's find-and-replace feature to quickly update the data.

You display the Find and Replace dialog box by choosing Find on the Edit menu. Alternatively, you can press Ctrl+F. Figure 8.1 shows the Find and Replace dialog box in Excel, after you click the Options button to show extra details.

Figure 8.1 You can use Excel's Find and Replace dialog box to look for text or numbers.

You can request that Excel search by rows or columns. If your worksheet is generally longer than wide (as most are), select By Columns to speed your search. Select the Match Case option if you want Excel to match the uppercase and lowercase letters in your search exactly.

Use Formulas if you are searching for part of a formula (you learn all about formulas in the next hour), use Values if you want Excel to search only the calculated cells (not within formulas), and use Comments if you want Excel to search through cell comments. Generally, you are searching through formulas, so Excel makes Formulas the default search target.

The Match Entire Cell Contents option indicates to Excel that a cell must contain your entire Find value and nothing else before it makes a proper match.

If you want Excel to replace the found value with another value, select the Edit, Replace command to display the Replace page of the Find and Replace dialog box, as shown in Figure 8.2.

Figure 8.2 Let Excel replace values for you.

Enter the text you want Excel to locate in the Find What field and type the text you want to replace that with in the Replace with field. Click the Replace All button if you want Excel to replace all occurrences of the found text. (Be sure that you want to replace all occurrences, or you'll possibly overwrite data unexpectedly.) Otherwise, click Find Next to find the next matching value and, if that is a value you want to replace, click Replace. If it is not a value you want to replace, click Find Next to locate the next occurrence.

Share This