How to create drop down list with images in Excel? (2022)

In Excel, we can quickly and easily create a drop down list with cell values, but, have you ever tried to create a drop down list with images, that is to say, when you click one value from the drop down list, its relative image will be displayed at once as below demo shown. In this article, I will talk about how to insert a drop down list with images in Excel.

How to create drop down list with images in Excel? (1)

Create a drop down list with image by Named Range feature

Create multiple drop down lists with images by a powerful feature

Insert multiple pictures based on cell values with a useful feature

Create a drop down list with image by Named Range feature

Normally, you can create a named range, and then use the linked picture for solving this task in Excel.

1. First, you should create two columns which contain the cell values and their relative images, see screenshot:

Note: To insert multiple images based on the cell values quickly and easily, please click to view here.

How to create drop down list with images in Excel? (2)

2. Then, you need to create a drop down list with the cell values, please click one cell where you want to output the drop down list value, and then click Data > Data Validation > Data Validation, see screenshot:

How to create drop down list with images in Excel? (3)

3. In the Data Validation dialog box, under the Settings tab, choose List from the Allow drop down list, and then select the cell values that you want to create the drop down list under Source section, see screenshot:

(Video) How To Tie Photos To A Dropdown List Selection In Excel

How to create drop down list with images in Excel? (4)

4. Then click OK button, and the drop down list with the cell values has been created, select one item from the drop down list, see screenshot:

How to create drop down list with images in Excel? (5)

5. Then, click Formulas > Define Name, see screenshot:

How to create drop down list with images in Excel? (6)

6. In the New Name dialog box, please do the following operations:

  • Enter a name called myimage into the Name text box;
  • Then copy and paste this formula: =INDEX(Sheet1!$A$2:$B$6,MATCH(Sheet1!$E$2,Sheet1!$A$2:$A$6,0),2) into the Refers to text box.

Note: In the above formula:

  • Sheet1!$A$2:$B$6: is the worksheet and range which contains the values and pictures you want to use;
  • Sheet1!$E$2: is the cell within the worksheet where you have created the drop down list;
  • Sheet1!$A$2:$A$6: is the list of cells that you are created the drop down list based on;
  • The variable number 2 is the column number containing the images. If your images are in column C, you should enter 3.

How to create drop down list with images in Excel? (7)

7. And then click OK to close the dialog. Then you need to copy and paste the corresponding picture based on the cell value in E2 from the original range to the cell F2, see screenshot:

How to create drop down list with images in Excel? (8)

8. Next, you should select the picture in cell F2, and then enter this formula =myimage (myimage is the range name that you named in step 5)into the formula bar, see screenshot:

(Video) How to create drop-down list with images in excel?

How to create drop down list with images in Excel? (9)

9. After entering the formula, press Enter key, and now, when you choose one item from the drop down list, its relative picture will be displayed immediately. See screenshot:

How to create drop down list with images in Excel? (10)

Create multiple drop down lists with images by a powerful feature

If you have Kutools for Excel, with its Picture Drop-down List feature, you can create multiple drop down lists with their relative images with only several clicks.

Note:To apply this Picture Drop-down List, firstly, you should download the Kutools for Excel, and then apply the feature quickly and easily.

After installing Kutools for Excel, please do as this:

1. First, you should create two columns which contain the values and relative images in your worksheet.

2. And then, click Kutools > Drop-down List > Picture Drop-down List, see screenshot:

How to create drop down list with images in Excel? (11)

3. In the Picture Drop-down List dialog box, if you have created the columns of cell values and images, please ignore step1, then, select the original data and image range and the output range, see screenshot:

How to create drop down list with images in Excel? (12)

4. And then, click Ok button, the drop down lists with images have been created into the selected cells, and when selecting an item from the drop down cell, its corresponding picture will be displayed as below demo shown:

(Video) Excel Picture Lookup: 5 easy steps for dynamic images

How to create drop down list with images in Excel? (13)

Free Download Kutools for Excel Now!

Insert multiple pictures based on cell values with a useful feature

To quickly insert the relative images based on the cell values without inserting them one by one, I can recommend a powerful tool-Kutools for Excel, with its Match Import Pictures utility, you can finish this job conveniently.

After installing Kutools for Excel, please do as this:

1. Click Kutools Plus > Import & Export > Match Import Pictures, see screenshot:

How to create drop down list with images in Excel? (14)

2. In the Match Import Pictures dialog box, please do the following operations:

  • Select the cell values that you want to insert the pictures based on under the Match range textbox;
  • Then click Add button to choose and insert the corresponding pictures into the list box;
  • And then click Import size button to specify the size for the pictures in the popped out Import Picture Size dialog box;
  • At last, click Import button.

How to create drop down list with images in Excel? (15)

3. Then, in the popped out dialog box, choose a cell where you want to insert the pictures, see screenshot:

How to create drop down list with images in Excel? (16)

4. Click OK, the pictures have been inserted into the specific cells which are consistent with the cell values.

How to create drop down list with images in Excel? (17)

(Video) How To Tie Photos To A Dropdown List Selection In Excel

Free Download Kutools for Excel Now!

More relative articles:

  • Increase Drop Down List Font Size In Excel
  • Drop down list is a very helpful feature in Excel, when you create drop down list in your worksheet, have you ever tried to increase the font size of the drop down list to make the selected record larger and more readable as left screenshot shown?
  • Create Multi Level Dependent Drop Down List In Excel
  • In Excel, you may create a dependent drop down list quickly and easily, but, have you ever tried to create multi-level dependent drop down list as following screenshot shown? This article, I will talk about how to create a multi-level dependent drop down list in Excel.
  • Highlight Rows Based On Drop Down List In Excel
  • This article will talk about how to highlight rows based on drop down list, take the following screenshot for example, when I select “In Progress” from the drop down list in column E, I need to highlight this row with red color, when I select “Completed” from the drop down list, I need to highlight this row with blue color, and when I select “Not Started”, a green color will be used to highlight the row.
  • Create Drop Down List But Show Different Values In Excel
  • In Excel worksheet, we can quickly create a drop down list with the Data Validation feature, but, have you ever tried to show a different value when you click the drop down list? For example, I have the following two column data in Column A and Column B, now, I need to create a drop down list with the values in Name column, but, when I select the name from the created drop down list, the corresponding value in Number column is displayed as following screenshot shown. This article will introduce the details to solve this task.

The Best Office Productivity Tools

Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%

  • Reuse: Quickly insert complex formulas, chartsand anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails...
  • Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range...
  • Merge Cells/Rows/Columns without losing Data; Split Cells Content; Combine Duplicate Rows/Columns... Prevent Duplicate Cells; Compare Ranges...
  • Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select...
  • Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
  • Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
  • Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic...
  • Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF...
  • More than 300 powerful features. Supports Office/Excel 2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features 30-day free trial. 60-day money back guarantee.

Read More... Free Download... Purchase...

Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

  • Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
  • Open and create multiple documents in new tabs of the same window, rather than in new windows.
  • Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!

(Video) Learn How To Create This Amazing Dynamic Drop Down List WITH PICTURES in Excel Today

Read More... Free Download... Purchase...

FAQs

How do I add an image to a drop down list? ›

Add <img> tag in dropdown content to insert image into dropdown list for each items. Note: In case the user needs the width of the content to be as wide as the dropdown button, please set the width to 100% (Set overflow: auto to get scroll on small screens).

How do I create a custom drop down list in Excel? ›

Create a drop-down list
  1. Select the cells that you want to contain the lists.
  2. On the ribbon, click DATA > Data Validation.
  3. In the dialog, set Allow to List.
  4. Click in Source, type the text or numbers (separated by commas, for a comma-delimited list) that you want in your drop-down list, and click OK.

How do I insert a picture into a list in Microsoft? ›

HERE IS THE STEPS:
  1. Create a FOLDER of images in SHAREPOINT > DOCUMENTS. Upload your pictures in the specified folder.
  2. Create SHAREPOINT LIST. Click ADD COLUMN > MORE. Insert Your COLUMN NAME > Choose HYPERLINK or PICTURE > FORMAT URL AS PICTURE.
  3. Go back to SHAREPOINT DOCUMENTS > Click the Name > Click The Picture.
17 Jan 2021

How do I put multiple Pictures in one cell in Excel? ›

To insert pictures into Excel cells, do the following:
  1. Choose to add images vertically or horizontally.
  2. Decide whether you want to: Fit cells to pictures. Fit pictures to cells. Specify your own size and click Next.
  3. Select images from your PC.
  4. Click Open.

Can you fill an Excel cell with an image? ›

Yes, you can insert an image into an Excel cell as follows. Paste an image into Excel, then resize the image and drag and drop it on top of a cell, as pictured below.

How do I create a drop-down list in Excel without Data Validation? ›

Instead of using data validation, you could use a Form Control Combo Box. It gives you a bit more control over the appearance of the drop down list. You can adjust the number of drop down lines in the Form Control Combo box, so you can show all 12 months, without a scroll bar.

How do I create a drop-down list in Excel that allows multiple selections? ›

To create the drop-down list:
  1. Select the cell or cells you want the drop-down list to appear in.
  2. Click on the Data tab on Excel's ribbon.
  3. Click on the Data Validation button in the Data Tools group.
  4. In the Data Validation dialog, in the Allow: list select List.
  5. Click in the Source: box.

Can an image be clickable? ›

To create a clickable image online, all you need is a JPG file and a website address (the URL). Just as you can add a link to any text on a web page or Word document, you can add a link to any image file, including JPGs, PNGs and GIFs.

How do I make an entire image clickable? ›

How To Create A Clickable Image In HTML? The <img> and the <a> tags together is the most common way of adding a clickable image link in HTML. In a webpage, after adding an image using the <img> tag, make it clickable by adding a <a> tag along with it.

What will you use to put image as list item marker? ›

The list-style-image CSS property sets an image to be used as the list item marker. It is often more convenient to use the shorthand list-style .

What are the 5 ways to insert an image? ›

Insert a Picture in Usual Ways:

Click the "Insert" tab next. Click "Picture" after that in the "Illustrations" group. Select a photo from the "Insert Picture" window now. Complete the task by clicking the "Insert" button.

Is there an image function in Excel? ›

The IMAGE function in Excel is designed to insert pictures into cells from a URL. The following file formats are supported: BMP, JPG/JPEG, GIF, TIFF, PNG, ICO, and WEBP. The function takes a total of 5 arguments, of which only the first one is required.

Can you fill a table cell with a picture? ›

Click on the Pictures option (it's in the illustrations group). In the 'Insert Picture' dialog box, locate the pictures that you want to insert into a cell in Excel. Click on the Insert button. Re-size the picture/image so that it can fit perfectly within the cell.

How do I put multiple pictures in one group? ›

Simply visit the Acrobat Online website and upload the files you want to merge. Reorder the files however you like and then click Merge files. After that, just download the merged PDF. This will combine all the JPGs-turned-PDFs into a single PDF you can easily share or view.

What is the fastest way to select multiple pictures in Excel? ›

Select all pictures in your Excel file with the selection pane.
...
Method 2: Select all images manually but using the selection pane
  1. Click on “Find & Selection” on the right hand side of the Home ribbon.
  2. Click on “Selection Pane”
  3. Now you can hold down the Ctrl. key and click on each picture in the list.
22 Aug 2016

How can I combine multiple images into one? ›

Open the Photo Gallery and locate the folder that contains photos you want to combine. Hold CTRL key to select multiple images and then click on the Photo Gallery's Create tab. Select the Photo Fuse feature and proceed to designate the area of the photo you want to replace.

How do you display an image or photo when an Excel user hovers over a cell? ›

Insert a pop-up picture by using comment
  1. Select a cell that you want to place the image at, and then right click to select Insert Comment from the context menu. ...
  2. Then a comment is inserted in the cell, and place the pointer at the border of the comment until the pointer change to a cross with arrows.

How do I lock an image in Excel so it doesn't move? ›

Please right-click the image and choose Size and Properties, then make sure that the Locked checkbox is checked.

What is a cascading drop-down list? ›

A cascading drop-down list is a series of dependent DropDownList controls in which one DropDownList control depends on the parent or previous DropDownList controls. The items in the DropDownList control are populated based on an item that is selected by the user from another DropDownList control.

What is dynamic drop-down list? ›

Drop-down Menu: Dynamic Select. The drop-down menu is a clear method of showing a list of data, allowing users to pick their choice from the list. This field can be categorized into two types based on the choice of selection types offered.

Can multiple items be selected in a Dropdownlist? ›

Dropdown lists are one of the most flexible elements in HTML. It is similar to that of the radio input, that is, only one item can be selected from a group of items by default. However, when the multiple attribute is used with the <select> element, we can enable the selection of multiple options from the list.

How do I make a JPEG image clickable? ›

About This Article
  1. Select the Slice Tool.
  2. Select the area you want to link.
  3. Right-click the selection and choose Edit slice options.
  4. Enter the URL for the link and other preferences.
  5. Click OK.
  6. Export the image as Save for Web (Legacy).
  7. Switch to JPEG and click Save.
  8. Save the files as HTML and Images.
18 Oct 2021

Can an image have clickable link? ›

A hyperlink is a clickable link and it means linking a word, a phrase, an icon, pdf files, a logo, and even an image file to another new web page.

What are clickable images? ›

An image that is used as a link. See hypergraphic.

What is an image with multiple hyperlinks called? ›

An image with multiple hyperlinks is called an image map. • Image map is used to connect links to different regions on the webpage. • An Image map is created by making certain regions on an image. clickable.

How do you make a grid clickable? ›

The ideal solution would be to modify the HTML code so that the entire grid element is wrapped in an <a> tag. This is valid, semantic HTML and would not require any further coding to make the grid element clickable.

How do I make a picture into a drop down menu in Word? ›

On the Developer tab of the ribbon, insert a Building Block Gallery content control. While the content control is selected, click the Properties button. At the bottom of the Properties dialog, select the custom gallery (and category, if needed) that contains the image building blocks. Click OK.

How can you add an image to a document using drag and drop method? ›

Drag and drop

Open a file browser window and locate the image you want to insert. Drag the image into the Writer document and drop it where you want it to appear.

How do I add an image to a drop down menu in Shopify? ›

From the Shopify dashboard, go to Products > All Products. Select a product. Click Add Image.

How will you design a drop down menu? ›

To create an effective drop-down menu, you should add one, two or more hover or selection effects to guide users. For example, when hovering on the below football drop-down menu, a bright blue background and the white icon will show up to highlight your focused menu item.

How do I create a drop down form? ›

How to Make a Dropdown Menu in HTML
  1. Step 1: Add a <label> element to your HTML document. This will be the name of your dropdown menu.
  2. Step 2: Add a <select> element. ...
  3. Step 3: Create <option> elements and place them inside the <select> element. ...
  4. Step 4: Add a default value from the dropdown list, if desired.
23 Aug 2022

How do I create a drop down button? ›

Example Explained. Use any element to open the dropdown menu, e.g. a <button>, <a> or <p> element. Use a container element (like <div>) to create the dropdown menu and add the dropdown links inside it. Wrap a <div> element around the button and the <div> to position the dropdown menu correctly with CSS.

What tool should we use to drag the image up and down? ›

Select the Move Tool from the Toolbar. Click on the image you want to move and drag it into the other document window. Press and hold Shift and release your mouse button to drop and center the image in the document.

What are the three methods to insert Images in to document? ›

If you are asking for the ways, then three ways are: i) Dragging and dropping the image in the document. ii) Choosing an image which is stored locally in our computer from the "Add image" option in the Insert tab. iii) Choosing an image from the internet from the "Insert image from web" option in the Insert tab.

How do you add multiple pictures to one product on Shopify? ›

Add images to existing variants
  1. From your Shopify admin, go to Products.
  2. Click the name of the product that you want to edit.
  3. In the Variants section, click the image icon to assign an image to that variant.
  4. Select a product image or click Add image to upload a new image.
  5. Click Save.

What is a mega menu? ›

A Mega Menu is a type of dropdown, expandable Menu that displays many choices in a two-dimensional layout. Mega Menus can improve site navigability, but this should be A/B tested.

How do I create a custom image section in Shopify? ›

Tap Edit.
  1. Use the dropdown menu to select the template you want to edit.
  2. From the theme editor sidebar, click the section or block that you want to add an image to.
  3. Click Select Image, and then do one of the following: ...
  4. Click an image to see a preview of the image in your theme. ...
  5. Click Save.

Videos

1. Excel Drop Down List Tutorial
(Kevin Stratvert)
2. Excel Magic Trick 881: Lookup Picture with INDEX & MATCH functions instead of INDIRECT Function
(ExcelIsFun)
3. Create a Picture Lookup in Excel
(Computergaga)
4. Create SMART Drop Down Lists in Excel (with Data Validation)
(Leila Gharani)
5. 🤔 How to Create a Drop-Down List in Excel
(Leila Gharani)
6. Excel Drop Down List Including Cell Colour Change: Colour Fill
(Chester Tugwell)

Top Articles

Latest Posts

Article information

Author: Kareem Mueller DO

Last Updated: 12/08/2022

Views: 5409

Rating: 4.6 / 5 (66 voted)

Reviews: 89% of readers found this page helpful

Author information

Name: Kareem Mueller DO

Birthday: 1997-01-04

Address: Apt. 156 12935 Runolfsdottir Mission, Greenfort, MN 74384-6749

Phone: +16704982844747

Job: Corporate Administration Planner

Hobby: Mountain biking, Jewelry making, Stone skipping, Lacemaking, Knife making, Scrapbooking, Letterboxing

Introduction: My name is Kareem Mueller DO, I am a vivacious, super, thoughtful, excited, handsome, beautiful, combative person who loves writing and wants to share my knowledge and understanding with you.