Quickly insert multiple pictures into cells and arrange them neatly
Kutools for Excel
Boosts Excel With 300+
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.
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.
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.
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.