Cannot paste picture into cell in Excel - always pastes on top of sheet

Question

Hello.  I'm trying to do what should be a simple task of pasting a picture into a specific cell in an excel sheet.  However, when I go to Insert--Pictures (as I've seen instructed on other threads), the picture never pastes into the cell, it only pastes on top of the whole sheet!  Once it does, changing Properties/Settings (e.g. move and size with cell), makes no difference; the picture remains an independent item on its own layer that I can re-size and move around the top of the sheet but cannot integrate into a cell.  It's like the picture is stuck permanently IN FRONT of the sheet and not in the cell I want it to be.

What settings am I missing here?

Answer 1

Hi Paul,

I am Vijay, an Independent Advisor. I am here to work with you on this problem.

Is the size of the cell large enough to contain the picture?

Try repairing your Office installation. First try Quick Repair (takes 5 - 10 mins) , if that doesn't help then try Online Repair (Takes more than 30 mins but less than 1 hour in general)

Note for Office 2013 and below - Please repair only if you have product key with you as sometimes it asks for the product key again after the repair.

How to repair instructions -

https://support.office.com/en-us/article/Repair...

Do let me know if you require any further help on this. Will be glad to help you.

Answer 2

Yes, I've tried re-sizing the cells and the picture to fit, but the picture remains independently layered from the sheet.  I can make it look like it fits, with a little effort and manipulation of cell and photo re-sizing; the problem is, because the picture is independent, you can't click to open it; you have to go through the trouble of re-sizing the photo out of the cell to see it.

Repair is not an option as I am using a business copy of the software.  Surely there is another way, or something missing?

Answer 3

Hello.  I'm trying to do what should be a simple task of pasting a picture into a specific cell in an excel sheet.  However, when I go to Insert--Pictures (as I've seen instructed on other threads), the picture never pastes into the cell, it only pastes on top of the whole sheet!  Once it does, changing Properties/Settings (e.g. move and size with cell), makes no difference; the picture remains an independent item on its own layer that I can re-size and move around the top of the sheet but cannot integrate into a cell.  It's like the picture is stuck permanently IN FRONT of the sheet and not in the cell I want it to be.

What settings am I missing here?

To the best of my knowledge this is standard functionality that you can't change.