If you attempt to copy a selection that is larger than 4 MB, you may receive an error message and you will be prompted to clear the Clipboard or close it. You cannot customize or resize the Office Clipboard Toolbar. You cannot paste a formula to the Office Clipboard. In other words, the Office Clipboard behaves like the Windows clipboard. To do this, point to Toolbars on the View menu, and then click Clipboard .
All command pastes all items in a column.
The data stored in the Office Clipboard is stored in HTML format. The contents of the Office Clipboard are deleted when the current session ends. If you have one Office program running, the contents of the Office Clipboard are deleted when you close that program. If you have multiple Office programs running, the contents of the Office Clipboard are deleted after you close the last Office program. There is no Visual Basic for Applications object model for the Office Clipboard, so there is no way to programmatically manipulate it.