Quickly insert multiple pictures into cells based on cell value in Excel

How can we insert pictures into cells by matching cell values and picture names in Excel? For example, I have a list of product names in Column A, to quickly insert corresponding product pictures beside the names, the Match Import Pictures utility of Kutools for Excel can do you a favor.

Click Kutools Plus >> Import & Export >> Match Import Pictures. See screenshot:

Import pictures by matching cell values and picture names, please do as follows:

1. Select the cell values based on which you will insert pictures. And then Click Kutools Plus > Import & Export > Match Import Pictures.

Note: You can also click the Match Import Pictures feature, and then click the range-selecting icon beside the Match range to select the cell values based on which you will insert pictures.

2. In the pop-up Match Import Pictures dialog box, you will see the cell values listed in the Match range column as shown in the red box below. Now, you can set the import size and import order as you need in More options section.

3. Click Add > File or Folder to choose the pictures that you want to insert as shown below.

4. Now, you will see the pictures are listed in the Picture column with their names matching the cell values. Click Import, and then select the first cell of the range where you will insert the pictures to.

5. All the pictures are inserted with their names matching the cell values, see screenshot:

Tips: In the above example, I selected Fill vertically cell after cell from the Import order menu. You can also insert the pictures horizontally based on the cell values as shown below by selecting the Fill horizontally cell after cell option.

Notes:

1. If there are no pictures' names matching any of the cell values, then no pictures will be inserted.

2. By checking the Case sensitive option in the dialog box, the utility will perform a case-sensitive match.

3. This utility supports importing pictures to multiple ranges even if the ranges have filtered/hidden rows.

4. This utility supports Undo (Ctrl + Z).

Demo: Quickly insert multiple pictures into cells based on cell value in Excel