✦Template Printable Ideas Insights

How to Create a Photo Link in Excel

By

Ever found yourself wanting to insert an image into a cell in Excel but didn't know how? You're not alone. While Excel isn't typically known for its image-manipulation capabilities, it's surprisingly easy to create a photo link in Excel. Let's dive into this helpful feature that can enhance your spreadsheets visually.

Before we begin, ensure you have the image you want to insert ready on your computer or in your Google Drive. If it's online, you'll need to use the image URL. Now, let's get started with two methods: using a local image and using an online image.

Using a Local Image

First, let's explore how to insert an image stored on your local drive:

How to Create a Hyperlink in Excel (3 Most Common Types of Hyperlinks)
How to Create a Hyperlink in Excel (3 Most Common Types of Hyperlinks)
🖼️How to Insert Photo in MS Excel 2019 | How to insert image in excel cell
🖼️How to Insert Photo in MS Excel 2019 | How to insert image in excel cell
How to Link Excel to PowerPoint and Save Hours of Time
How to Link Excel to PowerPoint and Save Hours of Time

1. Open your Excel workbook and navigate to the cell where you want to place the image.

Using Windows or Mac's default Paint or Preview

2. Right-click (or Control-click on a Mac) on the cell and select "Format Cells" from the context menu.

How to do a Picture Lookup in Excel
How to do a Picture Lookup in Excel
How to enlarge an image to print on multiple pages using Microsoft Excel Tutorial
How to enlarge an image to print on multiple pages using Microsoft Excel Tutorial
How to Insert Image into Excel Cells
How to Insert Image into Excel Cells

3. In the Format Cells dialog box, click the "Number" tab, then click the "Custom" category. In the "Type" field, type [Picture].

Using Excel's Insert feature

4. Alternatively, you can insert the image directly. Right-click on the cell and select "Insert" then "Picture" from the dropdown menu.

5. Browse to your local image, select it, and click "Insert". Your image should now appear in the cell.

how to create your first macro button in excel - step by step guide for beginners
how to create your first macro button in excel - step by step guide for beginners
How to Insert Image in Excel Sheet Cell || Add Picture in Excel Cell
How to Insert Image in Excel Sheet Cell || Add Picture in Excel Cell
Image Lookup – How-to show dynamic picture in a cell [Excel Trick]
Image Lookup – How-to show dynamic picture in a cell [Excel Trick]
an image of a workbook with labels in the bottom left corner and words on the top right side
an image of a workbook with labels in the bottom left corner and words on the top right side
Excel Magic Trick 881: Lookup Picture with INDEX & MATCH functions instead of INDIRECT Function
Excel Magic Trick 881: Lookup Picture with INDEX & MATCH functions instead of INDIRECT Function
How to insert picture in Excel cell, comment, header and footer
How to insert picture in Excel cell, comment, header and footer

Using an Online Image

Now, let's look at how to insert an online image, using its URL:

1. Follow the same initial steps as above: right-click on the cell, then go to "Format Cells" or directly "Insert", then "Picture".

Inserting directly from the URL

2. In the 'From a file' or 'From online sources' dialog box, switch to the 'From online sources' tab.

How to Insert Multiple Pictures at once in Excel and automatically size to fit cells(Using VBA Code)
How to Insert Multiple Pictures at once in Excel and automatically size to fit cells(Using VBA Code)
Extract Data from a Picture in Excel – Magic in One Click
Extract Data from a Picture in Excel – Magic in One Click
How to Insert Image in excel Cell | inset Photo in excel | excel tutorials in hindi
How to Insert Image in excel Cell | inset Photo in excel | excel tutorials in hindi

3. In the "Address" field, paste the URL of the online image and click "Insert".

Inserting from an image search

4. If you haven't got the URL, switch to Bing Image Search by selecting it from the dropdown menu next to "Search".

5. Type your search term and click "Search". Select an image from the results and click "Insert".

Remember, Excel stores the image link, not the image itself. This means the image will only appear if you're connected to the internet if you've inserted it from an online source.

Compact your new skills by experimenting with resizing images, adjusting transparency, and adding some alt text for accessibility. After all, learning how to create a photo link in Excel opens up a whole new dimension for your spreadsheets. Happy Excel-ing!