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?

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.

  • 1
    Oh I see.. it's a bit of long process, but I've created a AutoHotKey shortcut already (#v::send !es{Down}{Down}{Enter}) – glasnt Jul 17 '09 at 1:08
  • Sweet! AHK rocks. It seems like a bug to me, to be honest, but Microsoft will be Microsoft. – ChristianLinnell Jul 17 '09 at 1:09
  • There is no option to do a paste special either. – Adarsh Dec 20 '16 at 5:31
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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.