How to create a drop-down list in Excel 2007

Forum to talk about all the latest technologies - ins and outs!!
Post Reply
Admin
Site Admin
Posts: 317
Joined: Tue Sep 25, 2007 12:41 pm

How to create a drop-down list in Excel 2007

Post by Admin » Wed Apr 28, 2010 5:17 pm

Let’s say, you would like to create a drop-down list in Excel for your work purposes. Let’s imagine it’s about names of different animals i.e.you are a zoo keeper. :)

You have animal names in Column A (from A1 to A7), and you would like to create the drop-down list in Cell D1.

Image

Click on Cell D1, then click on the Data tab from the Menu bar. Now click on ‘Data Validation’ then choose ‘Data Validation’ from the list.

Image

The Data Validation window will open. Under ‘Settings’, choose ‘List’ from the ‘Allow’ menu. For ‘Source’ select your cells (here A1 – A7) from your spreadsheet. Now click on ‘OK’ to close the dialog window.

Image

Now a drop-down arrow will appear next to Cell D1, which if you click, will show you the names of your favorite animals. 8)

Image

But this shows how to create drop-down list in one cell.

If you would like to create the drop-down list for all cells in a column (let’s say in Column E), then select the column by clicking on column no. (e.g. Column E), and then follow the similar steps done for the single cell.

Image

Have fun. :)

P.S. you can download here the PDF version as well.




*Recommended:

Read wonderful articles (English & German) on Science & Tech, Environment, Health and many other topics only on BlogArena.

Art Marvin
Posts: 2
Joined: Thu Aug 06, 2020 2:21 pm

Re: How to create a drop-down list in Excel 2007

Post by Art Marvin » Tue Dec 22, 2020 1:10 pm

Now, it has become an easy process for me to create drop-down list because you have mentioned all the procedure very well. It is also a good sign for me that I have read more information about playing and enjoying casino games online. I am pleased to read this extremely informative post here on this website so thank you so much for helping me and many others who were looking for help in this regard.

Post Reply