Quickly insert multiple pictures into cells and arrange them neatly
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.
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.
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
Office Tab: Use handy tabs in Microsoft Office, just like Chrome, Firefox, and the new Edge browser. Easily switch between documents with tabs — no more cluttered windows. Know more...
Kutools for Outlook: Kutools for Outlook offers 100+ powerful features for Microsoft Outlook 2010–2024 (and later versions), as well as Microsoft 365, helping you simplify email management and boost productivity. Know more...
Kutools for Excel
Kutools for Excel offers 300+ advanced features to streamline your work in Excel 2010 – 2024 and Microsoft 365. The feature above is just one of many time-saving tools included.
