How to insert a batch image into Excel box

To insert images into cells in Excel, you have many different ways to perform them, manually or using formulas.

Inserting images on Excel is not a complicated operation, is a very simple operation on Excel. We can also insert images into cells with the usual way. For those who often have to synthesize employees, goods statistics, it is very good to have to insert the attached photo.

If the data file is short, we can do it manually, click the Insert button. But if it is a long table of information, it will take a lot of time to do it in this way. The following article will guide you how to insert images into cells in Excel.

  1. How to insert text into images in Excel
  2. Instructions for inserting a PDF file into Excel spreadsheet
  3. How to insert watermark, logo sink into Excel

Instructions for inserting images into cells in Excel

Method 1: Insert images into Excel manually

Step 1:

In the box to insert the image click the Insert button and then select Picture .

How to insert a batch image into Excel box Picture 1

Step 2:

Click on the image to insert into the box. In Format look down the Size item, select the arrow icon on the square .

How to insert a batch image into Excel box Picture 2

Display the interface Size and Properties dialog box, click on Properties , continue to click the Move and size with cells option to adjust the image size to the cell size.

How to insert a batch image into Excel box Picture 3

Now edit the image in the box and it will look like the image below.

How to insert a batch image into Excel box Picture 4

Method 2: Insert bulk photos into Excel box

As mentioned, doing this method will only apply to a small table of data, insert and edit fewer images. If the long data needs to be inserted at the same time, you should follow the procedure below.

Step 1:

First you put all the images you need to insert into Excel in the same folder. Then copy the image folder path to Notepad to use.

How to insert a batch image into Excel box Picture 5

Note that the user should display the image format for ease of implementation. How to display the image of the reference reader in How to hide files, show hidden files, view hidden folders and file extensions on Windows 7/8/10?

Step 2:

In the Excel file, we need to create a column with the product name corresponding to the name of the image. The image name column must be entered correctly with the image name you need to insert into Excel, including the image format as shown below.

How to insert a batch image into Excel box Picture 6

Next paste the path of the image folder into any cell in the Excel file.

How to insert a batch image into Excel box Picture 7

Step 3:

In the column between the 2 user tables enter the formula = & '' & VLOOKUP (product name; product name value corresponding to the image; 2; FALSE) and press Enter. Image path values, product names corresponding to images, you need to use the F4 key to fix the formula.

With the data table below, there will be the formula = = F $ 1 & '' '' & VLOOKUP (A2, $ D $ 2: $ E $ 4.2, FALSE).

How to insert a batch image into Excel box Picture 8

Step 4:

The result displayed will be the path of the photo folder with the image name.

How to insert a batch image into Excel box Picture 9

Continue dragging the first cell below to copy the formula and get the complete image path column as shown below.

How to insert a batch image into Excel box Picture 10

Step 5:

Users access the link below to download the xlsm Macros file to their computer and open the file in Excel.

 https://mega.nz/#!9MZRwCBT !x7wWj1NUjEE57f3sb6bGKy5K3HOVwHKwatBblwcwJ3M 

Step 6:

At the Excel data file interface, click the Developer tab and select Macros .

How to insert a batch image into Excel box Picture 11

Display the Macros dialog box, click on the file name ChenAnhTuDong.xlsm! ChenAnh and click the Run button to run the file.

How to insert a batch image into Excel box Picture 12

Note in case of error, you need to enable Macro running on Excel . Click Macro Security on the tool section.

How to insert a batch image into Excel box Picture 13

In the Macro Settings section, select Enable all macros to run macro files on Excel. You only enable this option when used, it should be turned off immediately after it is done.

How to insert a batch image into Excel box Picture 14

Step 7:

Display the Input box to scan all cells with the image path with the image name as shown.

How to insert a batch image into Excel box Picture 15

Next scan the image selection for the Picture section and click OK.

How to insert a batch image into Excel box Picture 16

Display the dialog box asking to delete the old image, click Yes to agree to enter the image into the box.

How to insert a batch image into Excel box Picture 17

The image results will be displayed in the Excel cell at the same time as the image below.

How to insert a batch image into Excel box Picture 18

Step 8:

Finally, you only need to delete unnecessary columns in the data file in Excel, or hide columns and cells in Excel.

How to insert a batch image into Excel box Picture 19

Complete results for image insertion statistics table as below. The image will automatically be resized to fit into the cell and aligned correctly between cells.

How to insert a batch image into Excel box Picture 20

These are two different ways to insert images into cells in Excel. Ideally, users should follow the way of inserting a series of images in Excel to perform quickly and save time instead of adjusting each image one by one.

See more:

  1. MS Excel - Lesson 4: Working with lines, columns, sheets
  2. How to temporarily hide rows and columns in Excel 2013
  3. Change color between different lines in Microsoft Excel

I wish you all success!

« PREV POST
NEXT POST »