Insert multiple pictures in Excel at once

The add-in is designed to insert multiple images in Excel worksheets in one go. Choose to add a group of pictures to a row or column, and every image will be put into a separate cell. You can adjust the size of each cell to fit the size of a picture, and vice versa. Alternatively, you can specify the desired size, and both cells and images will be adapted properly.

Microsoft's Pictures From File adds a pile of images to the center of your worksheet. So, you will have to drag them to the needed position and resize all images and cells manually.

Our add-in does all of the above for you and inserts pictures into Excel cells automatically.

To insert pictures into Excel cells, do the following:

1. Choose to add images vertically or horizontally.
2. Decide whether you want to:
   • Fit cells to pictures.
   • Fit pictures to cells.
   • Specify your own size and click Next.
3. Select images from your PC.
4. Click Open.

See a more detailed description here.

You can add as many images as you need provided you don't exceed the limit of Excel rows or columns and workbook file size.

You can insert pictures of the following most popular formats: .JPG, .JPEG, .PNG, .BMP, .GIF, .CGM, .DIB, .EMF, .EMZ, .EPS, .JFIF, .JPE, .PCT, .PCZ, .PICT, .RLE, .TIF, .TIFF, .WMF, .WMZ, .WPG.

Each picture should be at least 1 pixel wide or high. Also, to add images correctly, remember that the maximum cell height in Excel is 546 pixels, while the maximum cell width is limited to 1793 pixels. If some of your images are larger, you'll get a notification message, and they will be resized correspondingly.

Your images will be copied, hidden, or filtered as well. The picture in the copied cell will be placed the same way as the original.