How to Use the Clipboard Task Pane in Excel 2010
The Office Clipboard can store multiple cuts and copies from any Microsoft Office program running under Windows, not just Excel 2010. In Excel, this means that you can continue to paste stuff from the Office Clipboard into a workbook even after finishing a move or copy operation.
Use the following techniques to work with the Office Clipboard in Excel 2010:
To open the Office Clipboard in its own task pane to the immediate left of the Worksheet area, click the Dialog Box launcher button in the lower-right corner of the Clipboard group on the Ribbon’s Home tab.
To paste an item from the Office Clipboard into the current worksheet, click the item in the Clipboard task pane to paste it at the position of the cell cursor.
You can paste all the items stored in the Office Clipboard into the current worksheet by clicking the Paste All button at the top of the Clipboard task pane.
To clear the Office Clipboard of all the current items, click the Clear All button.
To delete only a particular item from the Office Clipboard, position the mouse pointer over the item in the Clipboard task pane until its drop-down button appears. Click this drop-down button and then choose Delete from the pop-up menu.The Clipboard task pane appears on the left side of the Excel Worksheet area.
You can have the Office Clipboard task pane appear automatically after making two cuts or copies to the Clipboard in an Excel workbook. Just click the Show Office Clipboard Automatically option on the Options button pop-up menu. To be able to open the Office Clipboard task pane in the Excel program window by pressing Ctrl+CC, click Show Office Clipboard When Ctrl+C Pressed Twice on the Options button’s pop-up menu. Note that this option only opens the task pane by pressing Ctrl+CC: you still have to click the Close button on the Office Clipboard to close the task pane.