Paste items from the Office Clipboard in Excel 2007

Click the place where you want to paste and click on an item. That's it, the item is pasted. You can also paste all the items at once by clicking the Paste All button .

Note:
If the items in the Clipboard are all text-based, i.e., text copied from Notepad, WordPad, Word, Excel, Access, PowerPoint or other program then the Paste All button remains enabled. Also, if all the items are images then the button remains enabled.
On the other hand if the items are a collection of text-based and images then the button gets disabled.