none
how to embed a picture inside a cell RRS feed

  • Question

  • Hi all,

    I need to put a picture inside a cell and hope the cell will adjust its size accordingly. the picture can put there, but it seems be "floating" there instead of being embedded and embraced by the cell. When i do the Autofit Row Height, the picture size is not taken into accounted.

    thanks,

    Sheldon

    Friday, May 29, 2020 8:33 PM

All replies

  • Hi Sheldon,

    Autofit Row and/or column does not apply to the pictures. However, you can right click the picture and select Format Picture and set some properties. Depending on your version of Excel what type of dialog you get. However, in xl2016 it appears like the screen shot below on the right of the screen.

    I also have an example workbook to use VBA code (macros) to insert pictures. If interested then let me know 



    Regards, OssieMac

    Sunday, May 31, 2020 1:56 AM