Getting Started with Microsoft® Excel® 2003 Lesson 4: Moving, Copying, and Pasting in a Workbook

In this lesson, you will learn how to use the Cut, Copy, and Paste commands and buttons to move and copy cell contents, copy a range to another worksheet in the same workbook, and copy an entire worksheet to the same workbook or to a new workbook. You will also learn how to use the mouse pointer and the drag and drop method to copy ranges and worksheets. You will learn how to quickly enter data in a preselected range and how to copy formulas with mixed or absolute references. Next, you will learn how to group and ungroup worksheets and how to apply formatting to grouped worksheets. Finally, you will learn how to copy and paste using the Office Clipboard and Office Clipboard task pane.

Objectives

1. Move or copy using Cut, Copy, and Paste
2. Move or copy using drag and drop
3. Move or copy to another worksheet
4. Entering data in a preselected range
5. Copy formulas with mixed or absolute cell references
6. Format grouped worksheets
7. Move or copy an entire worksheet
8. Collect and paste using the Office Clipboard

Key Terms