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: 291
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.

Post Reply