Forum Index
shamskm.com Home
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

How to create a drop-down list in Excel 2007

 
Post new topic   Reply to topic     Forum Index -> Technology & How-To Forum
View previous topic :: View next topic  
Author Message
Admin
Site Admin


Joined: 25 Sep 2007
Posts: 268

PostPosted: Wed Apr 28, 2010 5:17 pm    Post subject: How to create a drop-down list in Excel 2007 Reply with quote

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. Smile

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



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.



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.



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



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.



Have fun. Smile

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.
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Post new topic   Reply to topic     Forum Index -> Technology & How-To Forum All times are GMT + 2 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group