How to Link Picture to Cell Value in Excel (4 Quick Methods)

When you have a larger dataset and you want to export an image from the particular cell values, a linked picture might be the best option. As the linked picture will be changed automatically if you change any cell values. In this guiding session, I’ll demonstrate 4 ways to link a picture to a cell value in Excel with proper explanation.


Download Practice Workbook


4 Methods to Link Picture to Cell Value in Excel

Let’s introduce today’s dataset where Sales of some Products are provided for two years i.e. 2020 and 2021 showing the Yearly Sales Variation. The entire dataset including the heading is available in the B4:D13 cell range.

Dataset

Now, you’ll see the ways of linking the picture to the values of the B4:D13 cell range.


1. Using the Paste Special Option to Get a Linked Picture

In the beginning method, I’ll show you the simple but effective paste options i.e. Linked Picture from the Paste Special option.

➤ To utilize the paste option, you have to select the B4:D13 cell range first and select any cell where you want to get the linked picture (e.g. F4 cell).

➤ Then, right-click and move the cursor over the rightwards arrow of the Paste Special option and pick the Linked Picture under the Other Paste Options feature.

Using the Paste Special Option

Immediately, you’ll get a linked picture in the F4 cell as shown in the following screenshot. If you look closely at the formula bar, you’ll get =$B$4:$D$13 which represents the cell values of the Yearly Sales Variation.

Excel Link Picture to Cell Value Using the Paste Special Option

Notably, this linked picture is not static, which means if you change any value in the original cells you’ll find the changed image.

For example, if you input the data of the Webcam product after removing the data of the TV, you’ll get the newly added product in the linked picture.

Excel Link Picture to Cell Value Using the Paste Special Option

Read More: How to Link a Website to an Excel Sheet (2 Methods)


2. Applying the Camera Tool to Link Picture to Cell Value in Excel

In addition, you may also utilize the Camera tool instead of using the Linked Picture paste option.

Most probably, you’ll not find the feature in Excel by default. But you can add it if you want. For this, you have to right-click on the ribbon and choose the Customize the Ribbon option.

Applying the Camera Tool

Next, you’ll see the dialog box namely Excel Options. Please follow the steps.

➤ Initially, click on the New Group and create a New Group (Custom).

➤ After doing that pick the All Commands and find the Camera command. Finally, click on the Add.

Applying the Camera Tool

Eventually, you’ll see the added command in the Insert tab as shown in the following screenshot.

Applying the Camera Tool

Right now, select the B4:D13 cell range and pick the Camera tool.

Applying the Camera Tool

Later, drag down the cursor following the plus sign located on the right side.

Applying the Camera Tool

Immediately, you’ll see the created picture that links with the raw data e.g. Yearly Sales Variation.

Excel Link Picture to Cell Value Applying the Camera Tool

Read More: VBA to Add Hyperlink to Cell Value in Excel (4 Criteria)


Similar Readings


3. Using the Hyperlink Option 

What if you want to get the cell value by clicking over an image? Let’s say, you have an image in your working sheet.

Using Hyperlink Option

To link a particular cell with this picture, you have to choose the Link option from the Insert tab while selecting the image.

Using Hyperlink Option

Shortly, you’ll get a dialog box namely Insert Hyperlink, and choose the Link to option as Place in This Document. Next, type the cell (e.g. B5) that you want to link while selecting the active working sheet i.e. Hyperlink.

Using Hyperlink Option

After pressing OK, your existing image is linked with the specified cell. After clicking on the image, it shows the B5 cell representing the url of ExcelDemy.

Excel Link Picture to Cell Value Using Hyperlink Option

Read More: Excel Hyperlink with Shortcut Key (3 Uses)


4. Link Picture to Cell Value Dynamically in Excel

In this method, you’ll explore the process of linking the picture with the cell value dynamically. Please follow the step-by-step process.

Step 01: Insert the Pictures 

Assuming that you have Logo pictures of some Social Media service as shown below screenshot.

Inserting Picture

For your convenience, I am showing the process of inserting images in Excel.

➤ Firstly, select a cell and click on the This Device command which can be added by using the Customize the Ribbon option.

How to Insert Picture in Excel

➤ After adding the images, go to the Format Picture option (right-click or go to the right side of your spreadsheet). Then, check the circle before the Don’t move or size with cells option. Later, adjust the row height and width of the cells according to the size of the picture.

Format Picture

Step 02: Define the Names

Using the Name Manager tool, you can easily define the names of social media companies with their corresponding logo. After selecting the B5:C7 cell range, pick the option Create from Selection. And keep the box before the Left column is checked.

Excel Link Picture to Cell Value Link Picture to Dynamically

Step 03: Create a Drop-Down List

To make the selection more interactive, you may create the drop-down list using the Data Validation tool. Choose the Data Validation tool from the Data tab while keeping the cursor over the E5 cell.

Excel Link Picture to Cell Value Link Picture to Dynamically

Subsequently, you’ll see the following dialog box. So, choose the List from the drop-down list of the Allow option and set the Source as $B$5:$B$7 and press OK.

Creating Drop-down List

Then, you’ll get an interactive drop-down list as shown in the below screenshot.

Excel Link Picture to Cell Value Link Picture to Dynamically

Step 04: Paste the Picture

Right now, paste any picture from the C5:C7 cell range using the Link Picture paste option as shown in the first method. Remember, this picture is not dynamic.

Excel Link Picture to Cell Value Link Picture to Dynamically

Step 05: Utilizing the INDIRECT Function to Link

For making the pasted picture dynamic, you need to apply the INDIRECT function which returns the cell values defined by any text string.

So, open the Name Manager again and click on the New option to create a new defined named range.

Named Manager

Next, specify the Name as Logo and insert the following formula in the space after the Refers to option.

=INDIRECT('Dyanamic Link'!$E$5)

Here, the ‘Dynamic Link’ is the current sheet name and $E$5 is the name of any Social Media.

Excel Link Picture to Cell Value Link Picture to Dynamically

Again select the pasted picture and insert the following formula in the formula bar.

=Logo

Excel Link Picture to Cell Value Link Picture to Dynamically

Finally, your picture is linked dynamically. If you choose any option from Social Media, the picture will be changed automatically.

Excel Link Picture to Cell Value Link Picture to Dynamically

Here, I selected Facebook, and the picture in the F5 cell is changed automatically.

Read More: How to Create Dynamic Hyperlink in Excel (3 Methods)


Conclusion

That’s the end of today’s session. From the beginning to the end, I discussed the 4 ways to link a picture to a cell value in Excel. I strongly believe this article will be highly beneficial for you. Anyway, if you have any queries or recommendations, please share them in the comments section below.


Related Articles

Md. Abdul Kader

Md. Abdul Kader

Hi! I am Abdul Kader and presently working as ‘Excel & VBA Content Developer’ at Exceldemy. I publish my articles related to Microsoft Excel here. In 2019, I completed my graduation in Urban and Regional Planning from Chittagong University of Engineering and Technology. Having extreme eagerness to learn, I want to develop my skills and capabilities higher.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo