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

Speed Data Entry

Excel can often predict what data you want to enter into a worksheet. By spotting trends in your data, Excel uses educated guesses to fill in cell data for you. Excel uses data fills to copy and extend data from one cell to several additional cells.

To Do: Use Data Fills

One of the most common data fills you perform is to use Excel's capability to copy one cell's data to several other cells. You might want to create a pro forma balance sheet for the previous five-year period, for example. You can insert a two-line label across the top of each year's data. The first line would contain five occurrences of the label Year, and the second line would hold the numbers 2003 through 2007. To use the data-fill feature in Excel to create the five similar labels, perform these simple steps:

1. Click the B3 cell to move the cell pointer there.
2. Type Year . Don't press Enter or any cell-moving keys after you type the label.
3. Locate the cell's fill handle in the lower-right corner.
4. Drag the fill handle to the right across the next four columns. As you drag the fill handle, Excel displays the pop-up label Year indicating the value that will be automatically entered in the new cells.
5. Release the mouse button. Excel fills all five cells with the label.

If you drag the fill handle down, Excel copies the label down the column. Although the Edit, Fill command performs the same function as the fill handle, dragging the fill handle is much easier than selecting from the menu. Ctrl+D performs the same operation as Edit, Fill, Down.

Share This