The Insert Pictures add-in is designed to make your tables look presentable and enjoyable. See how to add images into Excel cells in one go with this small tool.
Video: How to insert multiple images in Excel
Before you start
Prepare your pictures by renaming them, since they will be put in the same A > Z order as stored on your PC.
How to insert pictures into Excel column
- Open your Excel file where you want to add images.
- Select the uppermost cell of the column for pictures.
- Find and click the Insert Pictures icon in the Utilities group on the Ablebits Tools tab:
- Select Vertically and choose one of three size options for your pictures:
- Pick the images you need via the Select files window:
Tip. Keep Ctrl pressed on your keyboard to choose certain pictures. Or press Ctrl + A to select all images at once.
- Click the Open button and enjoy your visually appealing table with pictures.
How to insert pictures into Excel row
To position images in a row go to Insert Pictures > Horizontally on the Ablebits Tools tab and then repeat the same steps as described above:

The only difference is that when you insert pictures in a row, you should consider image and cell width rather than height.
Note. Please remember that the maximum cell width in Excel is limited to 1793 pixels. If some pictures are larger, they will be resized accordingly. In this case, the add-in will notify you with a corresponding message:
Responses
Hi,
Is it possible to insert images from a URL in a cell ?
Regards
/Domenico
Hi Domenico,
Thank you for the question but no, unfortunately, the tool does not let you insert images from URL.
Please do not hesitate to ask any other questions!
Is it possible to specify the both height & width both before inserting the pictures.
Rgds/Vikas
Thank you for your question, Vikas.
No, at the moment you can't specify both height and width for inserted images.
I will forward this idea to our developers though and they will see if it's technically possible to implement the feature to one of the future version of the tool.
Thank you.
I have problem with inserting picture..
When insert picture automatically the will be a copy of my sheet, so if I add 10 picture there will be totally 11 sheet.
Could you advise me what to do please?
Hello Mohammed,
Thank you for the comment. Please click on the add-in's icon and uncheck the Back up the worksheet option. Thank you.