Microsoft® Office Excel 2003 Inside Out

Chapter 7. Worksheet Editing Techniques

• Copying, Cutting, and Pasting

• Inserting and Deleting

• Undoing Previous Actions

• Editing Cell Contents

• Finding and Replacing Stuff

• Editing Multiple Worksheets

• Getting the Words Right

Cut and paste. Insert and delete. Undo and redo. It all seems elementary, but as always in Microsoft Excel, there are features hidden beneath the obvious approach to even the simplest task, as well as solutions to problems you probably never even thought of. We'll cover all the essential editing techniques, including multiple-sheet editing, checking spelling, selective pasting, and creating data series. This chapter dives deep into the pool of possibilities.

Copying, Cutting, and Pasting

When you copy an item, Excel saves it in memory, ...