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

Reviewing Cut, Copy, and Paste in Excel

If you have mastered the Copy, Cut, and Paste commands in Word, those commands in Excel will be a breeze for you. As with Word and the other Office products, Excel uses the Office Clipboard to hold data that you are copying, cutting, and pasting from within or between worksheets. Alternatively, if you open two workbooks at the same time and display both on your screen (by selecting Window, Arrange), you can easily copy, cut, and paste between the two workbooks by dragging content from one worksheet to the other.

To copy data from one location to another, select the cell or cells you want to copy and then click the Copy toolbar button (or press Ctrl+C) to copy the worksheet contents to your Clipboard. The contents stay in the original location because you elected to copy and not cut the cells. To paste the Clipboard contents to another location, click the cell to indicate the upper-left corner of the target range. Then, click the Paste toolbar button (or press Ctrl+V). Excel overwrites the target cells with the pasted contents, so be sure of the paste target when you paste Clipboard data.

Excel supports drag-and-drop editing, so after you select the cells to copy, press Ctrl and drag the selection to its new location. You must drag the selection by pointing to one of the selection edges; if you attempt to drag from the center of a range, Excel modifies which cells are selected. When you release your mouse button and the Ctrl key, Excel pastes the contents to the target location. Of course, drag-and-drop editing works only when you can see both the source and the target copy and paste locations.

To cut contents and place them elsewhere, just select the cells that you want to cut and click the Cut toolbar button (or press Ctrl+X). Excel removes the selection from its original location and places the selection on your Clipboard. You then can paste the Clipboard contents elsewhere. In effect, cutting and pasting performs a movement of the selected data. If you want to move the selection with your mouse, drag the selection without first pressing Ctrl as you did when copying the contents.

Share This