Excel Guides

Clearing Large Clipboard Entries in Excel

If you're working with a lot of data in Excel, you may find yourself running into the dreaded "Clipboard is full" error message. This can happen when you try to copy and paste a large amount of data, or if you have an application that is constantly writing to the clipboard. There are a few ways to clear the clipboard and free up some space.

Method 1: Use the Clear Clipboard Command

Excel has a built-in command that will clear the contents of the clipboard. To access it, open the Excel application and then press Alt + H. This will open the Home tab in the ribbon. From here, click on the Clipboard group and then click on the Clear Clipboard button.

This will clear the contents of the clipboard and should allow you to copy and paste again without any issues.

Method 2: Use a Macro

If you find yourself having to clear the clipboard often, you can create a macro to do it for you. This way, you can just run the macro whenever you need to clear the clipboard instead of having to go through all the steps manually. To do this, open the Visual Basic Editor by pressing Alt + F11. Then, create a new module and paste in the following code:

Sub ClearClipboard() 

    Dim DataObj As New MSForms.DataObject 

    DataObj.SetText "" 

    DataObj.PutInClipboard 

    Set DataObj = Nothing 

    Application.CutCopyMode = False 

 End Sub

This macro will simply create an empty data object and write it to the clipboard. You can then run the macro by pressing Alt + F8, selecting it from the list, and clicking Run. Alternatively, you can assign a shortcut key to run the macro by going to Tools > Macro > Macros. Select your macro from the list and click Options. From here, you can assign a shortcut key under "Shortcut key". Once you've done this, just press that shortcut key whenever you need to clear the clipboard.

Method 3: Use Third-Party Software

There are also some third-party applications that can help you manage your clipboard better and clear it when necessary. One such application is ClipDiary. This application runs in the background and keeps track of everything that's copied to your clipboard. It then allows you to access your clipboard history so that you can easily paste something that you previously copied without having to re-copy it.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.