You can add a drop-down list in a cell using Excel Validation option. Adding a drop-down in a cell does not required any advance macro or coding kind of thing, the option is available within the menu options in Excel 2003, 2007, 2010 and 2013. Today we will learn creating a drop-down list in Excel and we would be using snapshot and menu options from Excel 2007

Step #1: First add a list of items in the sheet as following:

A B
1 DEPARTMENT Accounts
2 Admin
3 HR
4 Treasury

Step#2: We have added here four departments in B1, B2, B3 and B4. We will add these items into drop-down list items in cell A1 where we have initially put a simple text- Department. Now select the A1 cell.

Step#3: Click on Data Validation option in Data menu and select Data Validation option (First option).

Step#4: Data validation dialog box will be open where you need to select List as Allow and select the range B1 to B4 as Source, finally click OK.

Now you can see drop-down icon at right side of Cell A1 and the list of all items on clicking on that icon.

You can drag down or copy and past A1 cell value where you want use this drop-down list.

 

author image

About admin

You Might Also Like...

Excel Right Left and Mid Functions
Hirdesh Bhardwaj

2 Comments

  1. Iki minangka konten sing terkenal!

  2. HelloHey thereHeyGood dayHowdyHi thereHello thereHi! Do you know if they make any plugins to protectsafeguard against hackers? I’m kinda paranoid about losing everything I’ve worked hard on. Any suggestionsrecommendationstips?

    https://web.notifyninja.com/top6pro.com

Leave a Reply

Your email address will not be published.

Enjoy the tutorial? Please spread the word :)

Follow by Email
Facebook
Facebook
Google+2k
Google+
http://hirdeshbhardwaj.com/2016/11/21/drop-list-excel
YouTube75
YouTube