How to compress pictures loaded using the IMAGE() function in excel?

Question

I am loading images to a worksheet using the IMAGE() function, but this results in a very large file.

Is there a way to compress these images? Since the IMAGE function does not actually paste a picture, the Picture Format tab is not available.

Answer 1

Hi,

There is no method currently available by which you can compress your images using the image() function but here's what you can do.

Instead of embedding images directly into the Excel file using image(), you can use hyperlinks to display images from external URLs. This won't increase the file size significantly, but it will need your internet connection to load the images.

Or you'll just have to compress your images before-hand and keep them with you. You can use online tools for compressing images in bulk.

Best Regards.