Add a image to excel-And let the image align center-How can do?

as the title say.how can i do?
i use the Picture.Left、Picture.Top、Picture.TextHorizontalAlign = Center and so on…
i have try some method,but can’t work.

help me…
thank you.

Hi,

Please see this thread and let me know if it is helpful.

Insert picture inside a cell and adjust cell’s height and width accordingly.

i think this is not the result i want

i want the effect is the picture align center horizontal and vertical.
and the picture not cover the cell’s border line.

can i add a web image?

the effect like this:picture below.
Link

Hi,

Yes, you can load the web image. Please see

Load a Web Image (from a URL) into an Excel Worksheet

I am afraid, you will have to set the row height and column width and then reposition the image, so that it looks centrally aligned both vertically and horizontally.

can you give me a demo that implement the effect :the picture up .

thank you.

why can’t set the picutre position>???

resloved.
thanks