The office clipboard in Excel is an extension of the Windows clipboard. While the Windows clipboard holds only the last item copied, the office clipboard can hold up to 24 different entries.
The office clipboard provides a way around the limitations of autocomplete feature, which stops working whenever a blank cell is left during data entry.
Copying multiple entries to the clipboard
- Click on the Home tab of the ribbon.
- Click on the clipboard dialog box launcher to open the clipboard viewer - see image above.
- The clipboard viewer must be opened first for this procedure to work.
- Click on the first entry to be copied.
- Click on the copy command on the Home tab of the ribbon directly above the clipboard dialog box launcher.
- The first entry should be visible in the clipboard viewer.
- Click on the second entry to be copied.
- Click on the copy command.
- Both the first and second entries should be visible in the clipboard viewer.
- Continue adding entries to a maximum of 24. If more than 24 are entered, the first entries are removed from the clipboard viewer.
Copying a data series to the clipboard
If you have a series of data, such as a list of names, that you will be entering repeatedly in the same order into a worksheet, using the clipboard can simplify entering the list.
- Drag select the entire list in the worksheet.
- Click on the copy command. The list will be set as one entry in the clipboard.
Using the clipboard to add data to a worksheet
- Click on the cell in the worksheet where you want the data to be located.
- Click on the desired entry in the clipboard viewer to add it to the active cell.
- In the case of a data series, when pasted into the worksheet, it will retain the spacing and order of the original list.
- If you wish to add all entries to the worksheet, click the Paste All button at the top of the clipboard viewer. Excel will paste each entry into a separate cell in a column starting with the active cell.