How to Use and Manage the Office Clipboard
When you use the cut, copy, and paste commands in Excel and other Office programs, that data, including text and images, goes into the Office Clipboard, which retains up to 24 of your previous entries. The Office Clipboard task pane lets you view the items in the Office Clipboard in the order in which they were copied. In Excel, access the Office Clipboard task pane by selecting Home and then choosing the Clipboard dialog box launcher.
Copy and Paste Data From the Clipboard
If you have data, such as a list of names that you’ll be entering repeatedly in the same order into a worksheet, using the Clipboard can simplify the task. Highlight the entire list in the worksheet, then press Ctrl + C. The list will be set as one entry in the Office Clipboard. To paste information from the Office Clipboard into your spreadsheet:
Clearing the Clipboard
If the Clipboard is full or you’re doing some housekeeping, it’s easy to delete items from the Office Clipboard individually, or all at the same time.