Page 227 - Excel 2013 All-in-One For Dummies

Copying and Moving Stuff Around 209
tab instead of pressing the Enter key, Excel copies the selected cell range
to the paste area in the worksheet without removing the marquee from the original range. You can continue to paste the selection to other areas in the worksheet without having to open the Clipboard task pane to recopy the cell range to the Clipboard. If you don’t need to paste the cell range in any other place in the worksheet, you can press Enter to complete the copy operation. If you don’t need to make further copies after using the Paste command, you can remove the marquee from the original selection simply by pressing the Escape or the Enter key.
Also, when you paste a cell selection that you’ve copied to the Clipboard (this doesn’t apply when pasting cells that you’ve cut to the Clipboard), Excel displays the Paste Options button in the lower-right corner of the cell selection (marked with the word Ctrl). When you position the mouse pointer over this Paste Options button (or press the Ctrl key), a palette of buttons divided into three sections (Paste, Paste Values, and Other Paste Options) appears as shown in Figure 3-13.
Figure 3-13:
The Paste Option button’s palette with the option buttons that commonly appear after pasting
a cell selection that’s been copied
to the Clipboard.
Book II Chapter 3
Editing and Proofing Worksheets