Quickly insert multiple images at once in Excel

Excel is useful and easy to use software for all users. The software meets most of the statistical reporting needs of analyzing and synthesizing data, but there are many developers of additional software for Excel to improve the usefulness. Today Dexterity Software will guide you how to quickly insert rows of images at once in Excel with the tool Ablebit for Excel.

Quickly insert multiple images at once in Excel Picture 1

Excel also has the Insert Picture tool for inserting images, so why did Software Tips choose Ablebits to recommend readers? Dexterity Software will perform the insertion of multiple images at once with two ways for you to read and compare!

Insert multiple images with the Insert Picture tool

First, the Software Tips show you how to insert multiple images using the Insert Picture tool available in Excel.

Step 1: Select the cell you want to insert the image => Click the Insert tab (1) => Click the arrow below the Illustration icon (2) => Select the Pictures (3) section .

Quickly insert multiple images at once in Excel Picture 2

Step 2: Insert Picture window appears. You choose the path to where to save the image you want to insert. Select the images to insert and press the Insert button .

Quickly insert multiple images at once in Excel Picture 3

Step 3: The selected images have been added in Excel. However, the position and size of the images are not automatically adjusted to the right cell.

Quickly insert multiple images at once in Excel Picture 4

Step 4: You have to adjust the images one by one to match the cells in the worksheet.

Quickly insert multiple images at once in Excel Picture 5

Insert multiple images with Ablebits Tools

How to download and install Ablebit for Excel

You can download the software here: https://www.ablebits.com/

After installing the Add-in Ablebits for Excel , turn off the Excel software (if opened before) and turn it back on. On the Ribbon of Excel will display an additional tab for Ablebits Tools .

Quickly insert multiple images at once in Excel Picture 6

Use Ablebits Tool to batch insert images at once

Step 1: Select the first cell you want to insert the image. On the Ablebits Tool tab (1) => Click the arrow under the Illustration icon (2) => Select the Insert Pictures icon (3) => If you want to add the image vertically select Vertical ; if you want to insert the image horizontally select Hozirontally (4) => Select Specify Height (5) to adjust the width of the cell and the size of the image to suit the presentation of the report.

Quickly insert multiple images at once in Excel Picture 7

Step 2: The Specify Height window appears. You type the height of the line you want to adjust and then press the Next button . (1cm is equivalent to 37.7 pixels).

Quickly insert multiple images at once in Excel Picture 8

Step 3: Select file window appears. You choose the path to where to save the image you want to insert. Select the images to insert and click the Open button .

Quickly insert multiple images at once in Excel Picture 9

Step 4: The images to be inserted automatically are aligned to the height of the cell you have installed.

Quickly insert multiple images at once in Excel Picture 10

Comparing the steps and results of the above two methods, you can see that using the Ablebits Tool is simpler, faster and more useful than inserting images using the usual Insert Picture tool in Excel. Hope this article is helpful for you to read. Good luck!