Microsoft Office Tutorials and References
In Depth Information
Chapter 8: Worksheet editing techniques
CHAPTER 8
Worksheet editing techniques
Copying, cutting, and pasting .....................191
Inserting and deleting............................206
Undoing previous actions .........................217
Editing cell contents .............................219
Finding and replacing stuff........................237
Getting the words right...........................244
Editing multiple worksheets.......................253
Auditing and documenting worksheets .............259
Outlining worksheets.............................271
Consolidating worksheets.........................276
CUT AND PASTE . Insert and delete. Undo and redo. It all seems elementary, but as
always in Microsoft Excel 2013, 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, filling cells automatically, creating data series, and outlining and auditing
worksheets.
Copying, cutting, and pasting
When you copy an item, Excel saves it in memory, using a temporary storage area called
the Clipboard. You capture the contents as well as the formatting and any attached
comments or objects.
For more information about comments, see “Auditing and documenting worksheets” later in
this chapter. For more information about objects, see Chapter 10, “Creating and formatting
graphics.”
When you copy or cut cells, a marquee appears around the cell. (We used to refer to this
scrolling dotted line as marching ants .) This marquee indicates the area you are copying or
cutting. When you cut cells, the marquee disappears after you paste the cells. When you
copy cells, the marquee persists after you paste the cells so that you can keep pasting these
cells in other places.
The Cut, Copy, and Paste buttons in the Clipboard group on the Home tab are just swell,
but you should know the keyboard shortcuts for the quintessential editing commands
listed in Table 8-1. You can click the equivalent buttons on the ribbon, but really, if you
never learn another keyboard shortcut, learn these. They work in most Windows programs.
191
Search JabSto ::




Custom Search