![]() Reuse: Quickly insert complex formulas, charts and anything that you have used before Encrypt Cells with password Create Mailing List and send emails.The Best Office Productivity Tools Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80% With this feature, you can easily create a dynamic drop-down list with values and pictures totally matching. Here recommend the Picture Drop-down List feature of Kutools for Excel. You can pick the fruit name quickly by creating a drop-down list containing all fruit names in cell G2 as below screenshot shown.Įasily insert images to related cells based on cell values with an amazing toolįor many Excel newbies, the above method is not easy to handle. See screenshot:įrom now on, when changing to any fruit name in cell G2, pictures in cell H2 will turn into corresponding one dynamically. Enter a fruit name such as Apple in cell G2, click to select the pasted picture, and enter formula =Product into the Formula Bar, then press the Enter key. Here I copy the apple picture and place it in cell H2.Ħ. Then paste it to a new place in current worksheet. Select a picture in your Pictures column, and press Ctrl + C keys simultaneously to copy it. You can change them as you need in the above formula.ĥ. The last number 2 is the column number containing your images. Then the Edit Name dialog pops up, enter Productinto the Name box, enter the below formula into the Refers to box, and then click the OK button. In the Name Manager dialog box, click the New button. Create two columns in your worksheet, the first column range A2:A4 contains the name of the pictures, and the second column range B2:B4 contains the corresponding pictures. While entering Pineapple in cell G2, the picture in cell H2 will turn into the corresponding pineapple picture.ġ. When entering Banana in cell G2, the banana picture will be displayed in cell H2. Insert and change image dynamically based on the values you entering in a cellĭynamically change image Based On Cell Values With an amazing toolĪs below screenshot shown, you want to display corresponding pictures dynamically based on the value you entered in cell G2. This article will show you how to achieve it. For example, you want the corresponding images to be dynamically changed with the different values you entering in a specified cell. In many cases, you may need to insert image dynamically in cell based on cell value. How to insert image or picture dynamically in cell based on cell value in Excel?
0 Comments
Leave a Reply. |