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

Copying and Moving Stuff Around 211
range are immediately brought forward and reflected in the correspond- ing cells of the destination range.
✦ Picture (U): Excel pastes only the pictures in the copied cell selection.
✦ Linked Picture (I): Excel pastes a link to the pictures in the copied cell
selection.
Taking it out of the Clipboard task pane
Excel puts the contents of all cell selections that you copy and paste (using the Copy and Paste command buttons or their keyboard equivalents) into
the Office Clipboard. In fact, as you edit your spreadsheet in this manner, the Clipboard stores the contents of up to the last 24 copied-and-pasted cell selec- tions (before replacing them with new copied-and-pasted selections). Up to that time, you can examine the contents of the Clipboard and even paste your cell selections in other places in your spreadsheet or in documents open in other programs that you’re running. (See Book IV, Chapter 4 for information about pasting Excel data from the Clipboard into other applications.)
To open the Clipboard task pane on the left side of the Excel program window, click the Dialog Box launcher in the Clipboard group on the Ribbon’s Home tab (the button in the lower-right corner of the Clipboard group with an arrow pointing downward at a diagonal 45-degree angle).
When the Clipboard task pane is displayed, it shows all the individual cop- ied-and-pasted items that have been placed there (up to a maximum of 24). While this pane is open, Excel also places there all selections that you cut or copy in the worksheet, even those that you paste by pressing the Enter key as well as those you don’t paste elsewhere.
If you want Excel to place all selections that you cut and copy in the work- sheet into the Office Clipboard even when the Clipboard task pane is not open, click the Collect Without Showing the Office Clipboard item on the Options button’s drop-down menu at the bottom of the Clipboard pane.
To paste an item on the Clipboard into a cell of one of your worksheets, click the cell and then position the mouse pointer over the item in the Clipboard task pane. When the item’s pop-up button appears, click it and then choose Paste from the pop-up menu, shown in Figure 3-13.
If you’re doing a lot of cut-and-paste work in a spreadsheet using the Clipboard, you can have Excel automatically display the Clipboard task pane as you do the editing. Simply open the Clipboard task pane, click the Options button at the very bottom, and then choose the Show Office Clipboard Automatically option from its pop-up menu to select this setting. When this setting is selected, Excel automatically opens the Clipboard task pane if you put more than two items in the Clipboard during your work session. To have Excel display the Clipboard task pane when you press Ctrl+C twice in a row (Ctrl+CC), choose the Show Clipboard When Ctrl+C Pressed Twice option from this menu.
Book II Chapter 3
Editing and Proofing Worksheets