Welcome to Excel Jet Consult blog post. In this Excel tutorial, we will see how to insert multiple pictures in Excel cells at once using the New Place in Cell functionality. Note, new feature is currently available to Beta Channel users of M365 as at the time of writing this blog post. Let’s get started
Video Tutorial
Bulk Pictures To Insert
In the screenshot below, we’ve got just four pictures we want to directly place in cells at once. The pictures are located in the Pictures folder of my local machine
Insert and Place Pictures in Cells
To bulk insert the pictures using the new place in cell:
- In the Pictures group of the illustration group of the Insert tab, click on Place in Cell
- Browse through the pictures location and use CTRL + A to select all the pictures as seen below
- Click on Insert
Voila! All the pictures are nice placed inside the cells as seen in the screenshot below
See you in the next video