Use the Office Clipboard to copy multiple items in Excel

The Office Clipboard in Excel and other programs in Microsoft Office extend the capabilities of the regular system clipboard. The Windows clipboard only contains the last item copied, while the Office clipboard keeps a longer history of data and offers more flexibility.

These instructions apply to Excel 2019, 2016, 2013, 2010, and Excel for Office 365. The Office Clipboard is only available on Windows PCs.

Contents
  1. Using and managing the Office Clipboard
  2. Copy and add data from the clipboard
  3. Clear the clipboard

Use and manage the Office Clipboard

When you use the copy or cut (move) commands in Excel and other Office programs, this data (text and graphics) goes to the Office Clipboard, which can store up to 24 of your previous entries.

Items in the Office Clipboard can be viewed in the order they were copied Taskbar Office Clipboard

To open the Office Clipboard task pane in Microsoft Excel, click the At home on the adhesive tape † Then click clipboard dialog

Copy and add data from the clipboard

If you have a series of data, such as a list of names, that you need to repeatedly enter in the same order on a worksheet, the clipboard can make it easier to enter the list.

All you have to do is select the entire list on the sheet. Then press the keys ctrl+c on the keyboard and the list is set as a single item in the Office clipboard.

  1. When you’re ready to paste the information from the Office clipboard into your spreadsheet, click cell on the worksheet where you want to place the data.

  2. Press desired input in the clipboard viewer to add it to the active cell.

  3. In the case of a data series or list, when pasted into a sheet, it maintains the spacing and order of the original.

  4. To add all records to a sheet, click the button paste everything on the top clipboard viewer

  5. Excel will insert each item into a separate cell in the column, starting with the active cell.

Clear the clipboard

When the clipboard is full, it overwrites the oldest entries first. However, sometimes you get a warning that the clipboard is full and that your last copy job has not been processed. In this case, you want to clear all entries or delete the entries you no longer need.

The easiest way to clear the Office clipboard is to click the button delete everything is located on the taskbar Office Clipboard † Clearing the Office Clipboard also resets the System Clipboard.

To remove individual items, hover over the clip you want to remove. Then click the arrow on the right and select remove

Closing all Microsoft Office programs also clears the Office clipboard, but the system clipboard remains active. However, because the system clipboard contains only one item at a time, only the last item copied is saved.

Leave a Reply

Your email address will not be published. Required fields are marked *