How to batch insert pictures in Excel and unify the sizes

Key points of this article

Before illustration, name the pictures in the order corresponding to the rows. This will save a lot of effort in aligning and checking later.
Select multiple pictures to insert at once, then hold down Alt and drag. The pictures will be adsorbed to the cell borders for easy alignment line by line.
When unifying the size, multi-select all pictures and enter the same set of height and width, and pay attention to lock the aspect ratio to avoid picture deformation.
When pictures need to be sorted or filtered along with the cells, the properties should be set to move and resize with the cells.
When there are a large number of pictures, you can consider macros to match the corresponding lines by file name, but be sure to back up the original file before running.

When making product catalogs, employee address books, or experimental sample sheets, it is often necessary to put a picture in each row. If you insert them one by one, it is not only time-consuming, but also easily misaligned. In the end, the size of each picture is inconsistent. Excel itself can complete batch insertion and unified size, but the order of operations needs to be paid attention to.

This article is written for readers who need to process dozens of images and don’t want to manually adjust them one by one. After reading, you will know how to insert multiple pictures at one time, how to make the pictures fit into the cells, how to unify the sizes, and what other methods can be used when there are many pictures.

The methods below are based on universal Excel functionality and do not rely on specific third-party tools. The menu locations of different versions are slightly different, whichever version you are using shall prevail.

How to insert pictures in batches and unify their sizes? One sentence conclusion

The direct conclusion is: first insert the pictures into the table in order, and then select multiple pictures to uniformly set the height and width; if you want the pictures to be strictly aligned with the cells, use the function of dragging with the Alt key or placing the pictures with the cells. Which one to choose, see the table below.

your situation	Recommended practices	reason
There are not many pictures, they just need to be neatly arranged on one side of the table	Multiple selections are inserted once, and then multiple selections are made to unify the height and width.	Fewer steps and quick results
Each row of images should fit into exactly one cell	First set the row height and column width, then use the Alt key to drag and adsorb, or use the function of placing pictures with the cells.	The picture position is bound to the cell, making the layout more regular.
The picture must correspond one-to-one with the number or name	Arrange the order by file name first, check line by line and then align	Once the order is messed up, it will be difficult to find it later.
There are a lot of pictures, such as hundreds	Consider using a macro to match the corresponding line by file name and back up the file first.	Manual dragging takes a long time and has a high error rate
Images need to be sorted or filtered frequently	Set the image properties to move and resize with the cells	Images will not stay in place after filtering

Before you start: Confirm these points first

Taking a few minutes to prepare before you start can avoid rework.

Naming and ordering of pictures. Name the pictures in a format such as 01.jpg and 02.jpg, corresponding to the row numbers of the table. When the file names are out of order, it is difficult to determine which picture corresponds to which row after insertion.
Original size of image. When the image pixels are too large, the file size will quickly increase after insertion, and the opening and saving of the table will become slower. You can compress it enough in the picture software before inserting it.
Structure of the table. Determine which column the image should be placed in, and set a uniform column width for this column. The position of the picture is based on the cell. The column width and row height are not determined, and each subsequent picture must be readjusted.
Image Proportions. When the proportions of the original image are inconsistent, it will be deformed if directly stretched to the same width and height. When you need a unified look, either accept cropping or leave blank space, don't stretch it hard.
Excel version. Some newer versions provide the option to place the image with the cell, and the image will follow the size of the cell. If your version doesn't have this option, use the alignment method to achieve the same effect.

Steps to insert pictures in batches and unify their sizes in Excel

The following takes the common "pictures arranged in a certain column, one in each row" as an example.

Put all the pictures into the same folder and name them in order of line numbers, for example, 01.jpg to 50.jpg.
Select the column in the table where the picture is to be placed, and adjust the column width of the column and the row height of the corresponding row to the approximate size you want.
Switch to the insertion-related ribbon at the top of Excel, select the command to insert pictures, enter the folder, hold down the Ctrl or Shift key, and select all pictures at once to insert them.
After inserting, the pictures will be stacked together. Drag them one by one to the vicinity of the corresponding row. This step only requires that the approximate position is correct, and precise alignment is left in the next step.
Hold down the Alt key while dragging the picture, and the picture will be adsorbed to the cell border, so that it can be quickly aligned to the upper left corner or four sides of the cell.
Hold down Ctrl and click to select all images one by one, and enter a unified height and width in the size settings of the image format. Modify the value in multi-select state, and all selected pictures will change at the same time.
Right-click the picture to enter the panel for setting the picture size and properties. In the property options, select Change position and size with cells. When sorting, filtering or adjusting column width, the picture will change along with the cells.
Save the file and scroll through the first few lines, the middle lines, and the last few lines to make sure the image is not misaligned or obscures the text.

📊 Core comparison

There are four common practices, each with its own applicable scenarios.

Method	The right amount	Advantages	Disadvantages
After multi-selection, insert and manually drag to align the settings	Within a few dozen sheets	No extra setup required, quick to get started	Dragging with many images takes time
Alt key to attach the cell	Tables that need to be strictly aligned with the cells	Precise alignment and neat layout	You still need to drag them one by one
Images are placed with the cells (newer version)	The image needs to change with the cells	Positions are more stable during sorting and filtering	Depends on software versions; older versions don't have them
Match by file name with macros	Several hundred or more	Automatically completed, reducing manual operation	You need to enable macros and require the file name to strictly match the line number

When using macros, pay attention to two points: first, only run the macro code with reliable sources; second, test on the replica first, confirm the correct match results before processing the official file. The specific method for macros will not be elaborated here. You can organize it by following the idea of "reading images from the folder, finding the corresponding cell by filename, placing the image in that cell, and setting a unified size."

After completion, check each item one by one

After inserting the image, it is recommended to check each item and fix any issues promptly.

Inspection items	How to see it	What should you do if there's a problem?
Check if the image corresponds to the correct row	Randomly check 3 to 5 rows and compare them with the file name or number	Reorder by file name, and rematch with macros if necessary
Whether the dimensions are consistent	Select the image to check if the height and width values match	After multi-selecting, re-enter the unified value
Whether the image is distorted	Check if the face, text, or circular objects are stretched	Restore the original proportions or switch to cutting methods to unify the appearance
Whether the image obscures the text	Check if the edge of the image is pressing against the cell content	Reduce the image size or appropriately increase the row height
Check if the sorting and filtering are misaligned	After sorting a column, check if the image follows	Check if it is set to move and resize with the cells
Is the file size too large?	View file size	Compress images before insertion, or remove unnecessary duplicate images

❓ Frequently Asked Questions (FAQ)

1. What should I do if I can't filter or sort images after inserting them?

First, check whether the image properties are set to move and resize with the cells. If not set, the image will remain in place after sorting and will not match the data.

2. Can images be automatically placed in the corresponding line by file name?

It can be implemented with macros. The idea is to read the file name, compare it with the number in the cell, and then place the image in the matching cell. Back up the file before running and test the results on the copy.

3. After unifying height and width, the image got distorted. Why did it change?

If the original image proportions do not match your set proportions, it will be stretched. First, confirm whether the aspect ratio is locked, then set the value according to the original proportions, or use cropping to unify the appearance.

4. There are many images, and the tables are getting bigger and bigger. What can be done?

Before inserting, compress the images into a table to display the actual required size, delete duplicate images, and try to avoid putting too many high-resolution images in the same table.

5. Can mobile or web spreadsheet software also batch illustrate?

Features may vary depending on platform and version, and some operations may not be fully replicated. In such cases, it is recommended to complete batch insertion and size adjustment on the computer side before handing them over to other devices for review.

📝 Summary

To batch insert images in Excel, the key is to first plan column widths, row heights, and image order, then insert multiple selections again, and finally unify the size and verify the correspondence. If there are few images, manually align them; if there are many, consider macros. Once you master this process, the time required to process images in bulk will be significantly shortened.

Open OmniDoc and process your table file