How to Create a Simple Drop-Down List in MS Excel 2007?

this post is derive from this link. this can be in microsoft excel 2007.

1.
 Step 1

Click on the cell in the workbook where you want your drop-down list to appear. Cell A3 is active in the image to the left (click image to enlarge it).

2.
Step 2
Click the Data tab, and on the Data Tools menu, click on Data Validation. The Data Validation dialog box will appear.

3.
Step 3
On the Settings tab, below Allow, click the down arrow and select List.

4.
Step 4
For a simple list, type the items in the Source box in the order you want them to appear in the drop down, separating them by a comma as shown is the image. Click the OK button.

5.
Step 5
Now, at the insertion point, you can click the down arrow to display the options, clicking on one to select it.

References:

http://www.ehow.com/how_4535524_simple-dropdown-list-ms-excel.html#ixzz1R7FQFMg

Advertisements
This entry was posted in Microsoft Excel 2007. Bookmark the permalink.

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s