Microsoft® Excel® 2010 Inside Out

Chapter 8. Worksheet Editing Techniques

Copying, Cutting, and Pasting

Inserting and Deleting

Undoing Previous Actions

Editing Cell Contents

Finding and Replacing Stuff

Getting the Words Right

Editing Multiple Worksheets

Auditing and Documenting Worksheets

Outlining Worksheets

Consolidating Worksheets

CUT and paste. Insert and delete. Undo and redo. It all seems elementary, but as always in Microsoft Excel 2010, powerful features are hiding beneath the obvious approaches to the simplest tasks; in fact, after reading this chapter, you’ll find solutions to problems you probably never even considered. We’ll cover all the essential editing techniques, including editing multiple worksheets, checking spelling, selectively pasting entries, creating data series, ...