Quickly insert multiple pictures into cells and arrange them neatly

Generally speaking, it is easy for you to insert one picture into worksheet, but if you want to insert multiple pictures into worksheet, it may difficult for you to arrange them neatly. With the help of Kutools for Excel's Import Pictures utility, you can quickly batch insert hundreds of pictures into a range of cells in their original size, or a specified size you set.

1. Click Kutools Plus >> Import & Export >> Import Pictures to display the Import Pictures dialog.

2. In the Import Pictures dialog, do as following operations:

1 ）Choose the picture format you want to import.

2）Click Add button, then choose File or Folder to add the pictures to the Picture List.

3） In the Import size section, you can choose the size of the pictures import.

If you choose Specify size, when you type a number into Height textbox, the width of the pictures will be auto changed. Of course, you can specify both of height and width for making all imported pictures in a same size.

4) Import order can be vertical or horizontal.

5) Click Import button to select a cell to start importing pictures.

3. Click OK. The pictures in the Picture List will be inserted.

: Select pictures in the Picture list, click Remove to remove it from the list.

: Clear all pictures in the Picture list.

Demo: Quickly insert multiple pictures into cells and arrange them neatly