CODEWITHSUNDEEP
excelimagealignment
Kevin Corry
Kevin Corry

Reputation: 155

I would like to align/centre a image within a cell in excel

I would like to align/centre a image within a cell in excel.

When I insert the image into a cell it goes to the top left of the cell. I can manually drag the image to the centre however this is very time consuming as I have multiple cells of various sizes. Dragging the cell by the bottom corner is not an option.(see image 2)

Image default position after insertion

Image

Upvotes: 5

Views: 36692

Answers (2)

Wolfgang Kais
Wolfgang Kais

Reputation: 4100

Here's how to achive this, provided that the image is stored in a file:

  1. Insert the image from an existing file
  2. Snap the borders of the image to the borders of the cell by holding down the ALT-key and dragging the image borders using the mouse (forget about the aspect ratio for just a second)
  3. Right-click the image, select "Change Picture..." and re-select the image file

Every time you change the size of the cell, use "Change Picture" again to repair the aspect ratio.

Upvotes: 4

João Reis
João Reis

Reputation: 131

Simply join the cells together and put the image inside them.

To do this, select the cells that you want and put Arrange All, then the cells will be together and you can put the image inside them.

Upvotes: 0

Related Questions