8

Is there a way to insert an image inside a cell?

When I choose "Insert -> Picture" it inserts it so it's floating over the cells. That's not what I want.

I want to be able to insert the image into cell A1, for instance.

3 Answers 3

4

Adding on to @Dean's answer, the "Send to Background" option is under the "Arrange" submenu in the image's context menu (i.e. right-click menu).

After you do it, the behaviour depends on how it's anchored.

enter image description here

The image seems to be anchored not just by its top-left corner, but also by its bottom-right corner. If the bottom-right corner is inside the same cell as the top-left corner, making the cell bigger won't affect the image's size. But if it's inside another cell, then it will.

Most "interestingly", if you make the cell smaller, then the image overhangs the next cell, and the bottom-right corner anchor finds a new home in it! Henceforth, it will behave as the image on the right: resizing with its home cell's size.

I can only assume that this insane functionality is there to mimic what happens in Excel, which, in turn, must have been a well-meant initiative by someone at Microsoft mutilated by some internal deadline or the victim of a bumpkin focus group, and forever preserved in this form by the doctrine of backward-compatibility.

A procedure for working around the beauty:

  1. Select cell.

  2. Insert > Picture > From File. This will align the top-left corner quite well to the cell.

  3. Resize the cell and the image. Make sure that the image just very slightly overlaps the cells on the right and bottom.

  4. Right click the image > Arrange > To Background.

Now the image will resize with the cell, and act as the cell's background in general. Voila! You can type into the cell, etc. To get rid of the image now, you will have to select the four cells (the main one and its neighbours to the right and bottom), and "Delete Contents" from its right-click menu.

3

Insert image in the normal way, then right click, Anchor > To cell.

There you have it. I don't understand why is it necessary to put in background, it's just working fast and fine.

1

send to background once the picture is properly aligned, its a way around locking it.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .