Add-in A-Tools allows use function (UDF) BS_PIC to display image. It can automatically adjust the height and width of the image according to the rate of the original, just declare the attribute RATIO = YES. Default it fill image with size of cell.
=BS_PIC("FileOrURL", ["Options"])
Example:
1. Display image by file name in your computer
=BS_PIC("C:\Path\PicFile.jpg")
If you want to adjust the height and width of the image according to the rate of the original
=BS_PIC("C:\Path\PicFile.jpg" ,"RATE=YES")
2. Display image by URL from internet - website
=BS_PIC("http://atoolspro.com/images/stories/atools/logoa-tools.png")
Video help how to type formula to displau image on cell of worksheet