How many items can you copy to the office clipboard

The Office clipboard is a handy alternative to the built-in Windows clipboard when you need to copy and paste content.

How many items can you copy to the office clipboard

Windows has always come with its own clipboard for copying and pasting items, and Windows 10 even offers a cloud clipboard to store multiple items and sync them across different computers. But Microsoft Office also has its own clipboard that can help you when you’re working with Word, Excel, PowerPoint, Outlook and other Office applications.

SEE: Microsoft 365: A cheat sheet (free PDF) (TechRepublic)

More about Software

  • Get Microsoft Office Pro and lifetime access to 5 top apps for $59.99
  • How to return first and last times from timestamps in Microsoft Excel
  • Checklist: Microsoft 365 app and services deployments on Macs
  • Google Workspace vs. Microsoft 365: A side-by-side analysis

The Office clipboard is available with the subscription-based Microsoft 365 and the one-time purchase version of Office but not with the free web-based flavor. The Office clipboard is able to store a large number of items at one time, allowing you to paste each item individually or paste them all in one shot. This clipboard also offers specific options that you can customize to control how and when it pops up to do its work.

Launch any of the following Office applications—Word, Excel, PowerPoint, Access or Publisher. Start a new document or open an existing one. Make sure the Home ribbon is the active one. For Outlook, start a new email or reply to an existing one. Then in any of these programs, click the launcher arrow icon in the lower-right corner of the Clipboard group on the ribbon. The Office clipboard appears as a pane on the left side of the screen.

SEE: 83 Excel tips every user should master (TechRepublic)

Select and copy or cut an item in your document. Like the Windows clipboard, the Office clipboard can store text and images. The item you copied or cut pops up in the clipboard pane. Continue to copy or cut additional items, and each one shows up in the pane with the most recent ones at the top (Figure A).

Figure A

How many items can you copy to the office clipboard

To paste an individual item in your document, simply click its entry in the clipboard pane. To paste all the items, click the Paste All button, and they’re pasted in the order in which you copied or cut them. To remove an individual item, hover over it, click its dropdown arrow and select Delete. To remove all the items, click the Clear All button (Figure B).

Figure B

How many items can you copy to the office clipboard

The items you copy or cut in one Office application appear in other Office programs. For example, open the Office clipboard in Word and Excel, and you’ll see the same items that you can paste between the two (Figure C).

Figure C

How many items can you copy to the office clipboard

By default, the Office clipboard pane nestles into the left area of the screen. But you can move it to the right side or anywhere else on the screen as a floating window. Just drag the pane at the top and drop it in the position you prefer (Figure D).

Figure D

How many items can you copy to the office clipboard

The Office clipboard offers a few options to tweak. Click the Options button at the bottom of the clipboard pane. The first option for Show Office Clipboard Automatically displays the clipboard the first time you cut or copy an item. The second option for Show Office Clipboard When Ctrl-C Press Twice displays the clipboard if you press Ctrl+C twice. The third option for Collect Without Showing Office Clipboard allows you to cut or copy multiple items without displaying the Office clipboard.

The fourth option for Show Office Clipboard Icon on Taskbar displays an icon for the clipboard in the System Tray. The fifth option for Show Status Near Taskbar When Copying shows a notification in the lower left or the screen when you cut or copy an item (Figure E).

Figure E

How many items can you copy to the office clipboard

Finally, the Office System Tray icon offers similar options to the Office clipboard pane. Right-click this System Tray icon. Show Office Clipboard shows the clipboard pane. Clear All removes all the items in the clipboard. Stop Collecting prevents further cut or copied items from being stored in the Office clipboard. And Options shows the same five options accessible from the clipboard pane (Figure F).

Figure F

How many items can you copy to the office clipboard

How many items can you copy to the office clipboard

Microsoft Weekly Newsletter

Be your company's Microsoft insider by reading these Windows and Office tips, tricks, and cheat sheets.

How many items can you copy to the new Office clipboard?

Microsoft Office Clipboard (Windows) Press Ctrl + C twice in a row while Word, Excel, PowerPoint, or another Office app is open, and the Office Clipboard will keep the most recent 24 items you've copied.

What is the maximum storage capacity of Office clipboard?

The maximum clipboard memory size for copy and paste operations is 65,535 KB. Because this limit includes metadata and formatting data, the actual data size must be somewhat less than 65,535 KB. To transfer larger amounts of data, use the client drive redirection feature.

How many items can you copy to the Office 2003 clipboard?

Every Office 2003 program uses the same Clipboard, which is housed in the Task Pane. The Clipboard can hold up to 24 items. Once items are cut or copied, they are automatically saved to the Clipboard.

Is there a limit on copy and paste in Windows?

For 32-bit applications GlobalAlloc can allocate blocks up to 2 GB in size or up to the amount of virtual memory the PC has, whichever is less. The Windows clipboard does not impose any other size limits.