![Xel 3 travel images](https://loka.nahovitsyn.com/59.jpg)
![xel 3 travel images xel 3 travel images](https://mediaim.expedia.com/localexpert/437100/1d8e7e36-fa1f-4473-bc9c-00b768736554.jpg)
You have now book marked cell A3 to be “Germany”. The names are created automatically – so now the text inside B3 is the name of the cell for A3. Go to:įormulas / Defined Names / Create from Selection – select right column. Highlight the image cells and your names – in this example A3:B8. You can do this the slow way, by selecting each cell and then typing the name inside the name box. It’s easiest to assign the text you use for your list as the cell name.įor example cell A3 should get the name “Germany”, A4: “France” and so on. For data source, select the range where you have your list. Go the cell where you’d like your drop-down to be. The rest will be proportionally distributed. For proper vertical distribution, make sure the first and the last image sit correctly in their cells. You can for example, align them to the left side and distribute them vertically. Now use the options inside picture tools to align the images properly. To make sure each image is inside its own cell, you can select the images – Shortcut key Control + A selects all images (make sure you click on an image first before you use the shortcut key, otherwise you select all the cells instead).
![xel 3 travel images xel 3 travel images](http://i.ytimg.com/vi/ms5t91lPWjs/maxresdefault.jpg)
You’ll see why in a bit…Īdjust the row height so your images have enough space. It should be surrounded by the cell borders. Make sure each single image is “inside” its own cell. Let’s get started… Step 1: Organize the pictures in separate cells
![xel 3 travel images xel 3 travel images](https://traveldir.co/wp-content/uploads/2018/03/mexico-quintana-roo-xel-ha-wide.jpg)
the flag for the country to reflect our selection: We’d like to select the country from our drop-down list,Īnd we’d like the image – i.e.
![Xel 3 travel images](https://loka.nahovitsyn.com/59.jpg)