4
I'm not sure if this is a global issue with excel, but it's happening on all the computers here (Excel 2002, XP SP2)
If you select a cell, and go Ctrl-V when there's a screenshot in the clipboard, the image gets placed in the cell you've selected.
However, if you're got a copy/paste of something say from MS Paint, or any other image, if you do the same thing, the image goes directly to the top of the sheet.
Any ideas why this happens?
glasnt
Posted 2009-07-17T00:47:27.507
Reputation: 257
4
Not sure why that happens - it's something to do with the way Excel handles different objects
Workaround:
Go to "Edit>Paste Special..." and select "Bitmap" instead of "Bitmap Image Object", it will paste correctly at your currently selected cell.
ChristianLinnell
Posted 2009-07-17T00:47:27.507
Reputation: 386
1
You might as well only Ctrl+V, then the image appear on the top cell, however, without selecting that image (since it's already selected), just press Ctrl+X for cutting, and then Ctrl+V in the same cell you actually wanted the image and it will appear there perfectly. This is the fastest way I found.
Pat
Posted 2009-07-17T00:47:27.507
Reputation: 11
There is no option to do a paste special either. – Adarsh – 2016-12-20T05:31:49.123
1Oh I see.. it's a bit of long process, but I've created a AutoHotKey shortcut already (#v::send !es{Down}{Down}{Enter}) – glasnt – 2009-07-17T01:08:29.170
Sweet! AHK rocks.
It seems like a bug to me, to be honest, but Microsoft will be Microsoft. – ChristianLinnell – 2009-07-17T01:09:44.193