Excel tutorials

Display Image or Picture From Another Worksheet

How to Display an Image from Another Worksheet based on the Criteria Value or Text Condition From Drop Down Menu in the Cell

In this tutorial I will show how we can on the worksheet in Excel to display a certain image or picture that you can choose from the drop down menu whether the image (picture) name or code or number value. This is a simple Excel example of a picture in the adjacent cell (or any cell) to another sheet based on the condition that there is a cell in another worksheet that there is a drop down menu or directly write the image name, number and the like as well as this condition can be obtained by a formula. There are many situations where this example can be used and it all depends on the needs of users of Excel.

In the tutorials in which I have already written about insert images from a folder and adjusting the size of a cell or display picture from the same worksheet. You can see similar actions as the previous step of this tutorial.

In the picture below you see Sheet1 where in the cell 'A1' is the name of the image (number, code, etc.). In 'B2' cell we want to display the picture from another worksheet to which it belongs name from the cell 'A1'. Here I used a cell 'B2' but this is irrelevant. You can use any cell in the Excel worksheet.

 

Display an image from another worksheet by selecting name from the drop down menu

In the picture below you see Sheet2 which appears in 'A' column list of all images with their names (or codes, numbers, etc.). In the 'B' column are inserted all the images in the classical way (Insert => Pictures). Therefore, the data are in the 'A2:B8' range.

List and view the inserted images on another worksheet in Excel

When we have prepared the form of a worksheet go to the next step in order to 'Sheet1', display an image from 'Sheet2', so my choice is made with the drop-down menu.

Necessary is to Excel Name Manager naming by the name of some formulas and cells. So click on the tab Formulas => Name Manager command and name the following formula. (see image below to create a new name in the Name Manager)

Name: ChangingPictures

Refers to: =OFFSET(Sheet2!$A$2;;;COUNTA(Sheet2!$A1:$A8);1)

Name: Pictures

Refers to: =OFFSET(Sheet2!$B$2;MATCH(DropDown;ChangingPictures;0)-1;0)

 How to define a new name with a formula in Excel Name Manager

The next step is to naming a cell 'A1'. So, select the 'A1' cell and in the 'Name Box' type 'DropDown'. (see image below). 

 How to define name of cell in Excel

And finally a look at Excel Name Manager looks like as shown below. 

 Named Formulas in Excel Name Manager to display images from another worksheet

All previous actions we have provided the necessary conditions for image display on 'Sheet1'.

Furthermore it is necessary to 'Sheet2' select 'B2' cell (which contain the first picture)
ATTENTION !!! Do not select the image, select the cell in which the first image. Well, then Copy from the Ribbon Tab.

Position the cursor on Sheet1 and select 'B2' cell in which the need to display an image. (here are accidentally identical addresses but do not you think that it must be so).

On the Home tab, click Paste and choose the Linked Picture (I) command. (see image below).

 Paste picture As Link in Excel

Now, we have a situation where the image (picture) will appear on Sheet1 and when selecting an image (picture) you see in the formula field, the following formula =Sheet2!$B$,
Delete this formula and type =Pictures

 How to set up a formula to a selected linked picture in Excel

Data Validation - Choose Image from List

Finally, the last action is to create a list of images in a 'A1' cell by the Data Validation. So select the 'A1' cell then click on the tab Data => Data Validation, select List, and type in the field Source: ChangingPictures

 Choose and List Image or Picture by Drop Down Menu from another worksheet

Finally, the result of this tutorial is to Display the a Image or Picture from another Worksheet based on selection from the Drop Down Menu

 Display or view pictures from another Excel sheet in the cell adjacent selection from the dropdown menu

Also, see another tutorials for Display Image/Picture

- Display an image in a cell with the same worksheet based on values, codes or text in the neighboring cell
- Insert images from a folder in the a selected cell, from the drop-down menu