How To Insert Bulk Image Links In Microsoft Excel

In this tutorial, we are going to learn how to insert bulk image links, so you can check and view these pictures quickly.

Firstly, you need to create a new folder and save all your pictures and your Excel file in it. Remember to rename all these pics.

Go to the Formulas tab and click on Define Name. type [=FILES(“E:\Desktop\Fruits\*.jpeg”)] in Refers to box. The goal of this step is to get the names of all the “jpeg” images in this folder.

Type [=HYPERLINK(B2&”.jpeg”,”View”)] in cell D2 and press Enter. When the cursor becomes a solid cross, click the drop-down to fill.