Here are 4 photos and the names I want to associate with each:Īs with some previous blog posts, I would strongly encourage you to watch the video. The goal here is to create a dropdown list of photo names, and have the related photo appear. Many of the processes I will use here have been discussed in previous posts, so if you need a refresher on any of them, just search my site for that topic and you should find a related post. Here is the link to the Dueling Podcast on this topic. This post came from a question asked on a LinkedIn user group forum and the response referenced a dueling podcast between Mr. If you get a preview, look for the download arrow in the upper right hand corner. You can download the file here and follow along. You can always ask an expert in the Excel Tech Community or get support in the Answers community.Here's how you can have a photo change based on the selection from a dropdown list in Excel: If you want to delete your drop-down list, see Remove a drop-down list.
For example, check to see if the cell is wide enough to show your updated entries. If the Source box contains a named range, like Departments, then you need to change the range itself using a desktop version of Excel.Īfter you update a drop-down list, make sure it works the way you want. Then click and drag to select the new range containing the entries. If the list of entries ends up being longer or shorter than the original range, go back to the Settings tab and delete what's in the Source box. In this example, you'd add or remove entries in cells A2 through A5.
If the Source box contains a reference to a range of cells (for example, =$A$2:$A$5), click Cancel, and then add or remove entries from those cells. For example: Fruits,Vegetables,Meat,Deli. When you're done, each entry should be separated by a comma, with no spaces. If the Source box contains drop-down entries separated by commas, then type new entries or remove ones you don't need. On the Settings tab, click in the Source box. Select the cells that have the drop-down list. In Excel for the web, you can only edit a drop-down list where the source data has been entered manually.
0 kommentar(er)
