Skip to main content

Quickly insert multiple pictures into cells and arrange them neatly

Author: Xiaoyang Last Modified: 2024-12-12

Kutools for Excel

Boosts Excel With 300+
Powerful Features

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.

shot import pictures 1

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

shot import pictures 2

1 )Choose the picture format you want to import.

shot import pictures 3

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

shot import pictures 4

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

shot import pictures 5

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.

shot import pictures 6

4) Import order can be vertical or horizontal.

shot import pictures 7

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

shot import pictures 8

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

shot import pictures 9

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

shot remove all: Clear all pictures in the Picture list.

Notes:

1. If your selected cells are more than the pictures that you need to insert, other blank cells will be filled with the pictures as its order.

2. Hidden rows will be ignored when import pictures.

3. Supports Undo.


Productivity Tools Recommended
The following tools can greatly save your time and money, which one is right for you?
Office Tab: Using handy tabs in your Office, as the way of Chrome, Firefox and New Internet Explorer.
Kutools for Excel: More than 300 Advanced Functions for Excel 2021, 2019, 2016, 2013, 2010, 2007 and Office 365.

Kutools for Excel

The functionality described above is just one of 300 powerful functions of Kutools for Excel.

Designed for Excel(Office) 2021, 2019, 2016, 2013, 2010, 2007 and Office 365. Free download and use for 30 days.

Screen shot of Kutools for Excel

btn read more      btn download     btn purchase