How to Clear Clipboard in Excel

The Office Clipboard in Excel

The term “copy-and-paste” has already become a set phrase for the simple and unimaginative method of producing content.

However, even such a trivial thing can be transformed into something bigger as it’s shown by a Microsoft Office feature called the Office Clipboard.

The Office Clipboard is a space where you can store the data you copied and then use it across all the Office apps. It means that if you open the clipboards in Excel and Word, you will see the same items that can be used in both of the applications.

In this guide, we will show how to open the Office Clipboard and manage its contents.

Why Clear the Office Clipboard?

The Office Clipboard can store only up to 24 items, and when you add the 25th element to it, the very first one is automatically deleted. You may get into trouble if you desperately need that first item and don’t remember where you copied it from.

There are more possible reasons why you may want to clear the clipboard:

  • you need to use someone else’s computer and don’t want this person to know what you did there;
  • you often work with confidential information and worry that it may leak out;
  • you just want to make your work in Excel quicker by storing only the necessary data.

Fortunately, optimizing your clipboard is a quick task if you know how to do it the right way. So, let’s roll up our sleeves and get down to business.

Step 1. Open the Office Clipboard Task Pane

For Windows users, accessing the Office Clipboard is a real piece of cake:

1. Click the “Home” tab.

2. Find the Clipboard group on the left side of the Ribbon and click the Clipboard dialog box launcher in the bottom right corner.

Click the Clipboard dialog box launcher

3. On the left side of the spreadsheet, you will see the Clipboard task pane where you can manage all the items stored there. Pay attention that there is a small icon next to each item, which shows its source.

The Clipboard task pane

Step 2. Clear the Clipboard

Now let’s learn how to trim down your clipboard list.

4. To delete an individual entry, hover over the item you want to remove in the Clipboard task pane. Then, click the drop-down button that appears and choose “Delete.”

Delete an item from the Clipboard

5. To clear the entire clipboard at once, click the “Clear All” button at the top of the Clipboard task pane.

Clear the entire Clipboard at once

Step 3. Customize Your Clipboard Settings

To make it easier for you to manage the clipboard, you can customize the Office Clipboard settings, saving yourself some time when copying or deleting any items.

6. Click the “Options” button at the bottom of the Clipboard task pane.

Click the “Options” button on the Clipboard task pane

7. You will see the drop-down menu where you can change the Office Clipboard settings.

The Office Clipboard settings

Let’s see what they can do.

Show Office Clipboard Automatically

This setting automatically displays the Office Clipboard whenever you copy an item. A good choice, but only if you use it all the time.

Show Office Clipboard When CTRL+C Pressed Twice

The Office Clipboard will be displayed when you press the CTRL + C combination twice in a row. This is a very convenient way to open it in a flash, and we highly recommend you enable this setting.

Collect Without Showing Office Clipboard

If this option is active, the new items are added to the Office Clipboard even when the Clipboard task pane is not displayed.

Show Office Clipboard Icon on Taskbar

This setting adds the Office Clipboard icon to the status area of the system taskbar when the Office clipboard is active. You can right-click on it to quickly access the Office clipboard, clear all items, stop collecting the data, or change the settings.

The display of the Office Clipboard icon is turned on by default, and that’s how it looks like:

The Office Clipboard icon

Show Status Near Taskbar When Copying

This setting is also enabled by default. When you copy something, it shows a message saying “Item collected” in the bottom right corner of your screen. A pretty useful option that allows you to track how much room is left in the clipboard.

"Item collected" message

In a nutshell, the Office Clipboard is a tool that is worth mastering. At least, now you know about its existence and can store the data you copy in a systematic and organized way.