![what are the different paste options in excel 2016 what are the different paste options in excel 2016](https://cdn.wallstreetmojo.com/wp-content/uploads/2014/05/Excel-2016-Ribbons-Tabs-and-Quick-Access-Toolbar-main.jpg)
![what are the different paste options in excel 2016 what are the different paste options in excel 2016](https://www.lifewire.com/thmb/o2-7whCu_8hHDHtVfC0AOvLCtVE=/1388x923/filters:no_upscale():max_bytes(150000):strip_icc()/ExcelCutRightClick-5c3591fec9e77c00014ecb45.jpg)
Again, I used "Create from Selection" and named cells B2:B5 based on the names in cells A2:A5. Step 4: Name the cells where the photos are located. Step 3: Locate where you want the dropdown list, and using Data Validation – Lists, enter the list based on what you named it. I first named the list from cells A2:A5 as "Wine" using "Create from Selection" on the Formulas tab. Step 2: Create the list for your Data Validation dropdown. In a future step we will be referencing the cell where that the photo is located, so this is an important step. Step 1: Load your photos onto a worksheet, and make sure each photo is contained within a single cell. I will go through the steps in a cursory fashion below, but the video will best explain the details to accomplish this. 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.
![what are the different paste options in excel 2016 what are the different paste options in excel 2016](https://cdn.extendoffice.com/images/stories/doc-excel/doc-restrict-to-paste-values-only/doc-restrict-to-patse-values-only-1.png)
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.
#WHAT ARE THE DIFFERENT PASTE OPTIONS IN EXCEL 2016 DOWNLOAD#
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. Here's how you can have a photo change based on the selection from a dropdown list in Excel: