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.
![How To Insert Bulk Image Links In Microsoft Excel How To Insert Bulk Image Links In Microsoft Excel](https://www.myofficetricks.com/wp-content/uploads/2021/10/image-6.png)
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.
![How To Insert Bulk Image Links In Microsoft Excel How To Insert Bulk Image Links In Microsoft Excel](https://www.myofficetricks.com/wp-content/uploads/2021/10/image-7.png)
Type [=HYPERLINK(B2&”.jpeg”,”View”)] in cell D2 and press Enter. When the cursor becomes a solid cross, click the drop-down to fill.
![How To Insert Bulk Image Links In Microsoft Excel How To Insert Bulk Image Links In Microsoft Excel](https://www.myofficetricks.com/wp-content/uploads/2021/10/image-8.png)
![How To Insert Bulk Image Links In Microsoft Excel How To Insert Bulk Image Links In Microsoft Excel](https://www.myofficetricks.com/wp-content/uploads/2021/10/image-9.png)
![How To Insert Bulk Image Links In Microsoft Excel How To Insert Bulk Image Links In Microsoft Excel](https://www.myofficetricks.com/wp-content/uploads/2021/10/myofficetricks.com_2021-10-15_08-39-13.gif)
Leave a Reply