How to insert images into Excel?

Hi.
Is there some tool or extension that allows drag and drop images in Excel?.
The image should be the size of the grid automatically, without having to adjust it.

Adjusting image by image takes a long time.

The best way is using macros (VBA).

There are some add-ins and also paid extensions to do this, but I think that’s not what you are looking for.

Stackoverflow is one of the best resources for programmers, and they have pretty much almost every code you need to adjust to your case.

For example like this:

There are some other examples, from other webs. This one may help you to start:
Insert and Resize Picture from Folder to Selected Cell
http://www.ic-ims.com/excel-examples/insert-and-resize-image-from-folder-to-selected-cell.html

Hope that help.

1 Like