The Office Clipboard enables you to “collect and paste” multiple items. You simply display the Office Clipboard, then copy or cut cells, text, or objects as usual. But instead of the Clipboard contents being replaced each time you use the Copy or Cut command, all items are stored on the Office Clipboard (Figure 66). You can then paste any of the items on the Office Clipboard into your Excel document.
The Office Clipboard works with all Microsoft Office applications—not just Excel— so you can store items from different types of Office documents.
This feature is also known as Collect and Paste.
If necessary, choose View > Office Clipboard (Figure 64) to display the Office Clipboard ...