Go Back   Wiki NewForum > Career Forum > Tech Forum & Tutorial > IT Forum > MS office Tutorials (2003 & 2007) > MS Excel 2003

Sponsored Links

MS Excel 2003 Step-by-step Excel 2003 Tutorials, Tips and Training

Views: 1735  
Thread Tools Rating: Thread Rating: 9 votes, 5.00 average. Display Modes
Old 01-26-2010, 11:26 AM
seema seema is offline
Join Date:
Oct 2009
Posts: 5,551
Default Topic 30: how to Create the Excel Drop Down List Menu?

Microsoft Excel 2003 allows you to build your own Excel drop down list!

this feature is really cool.Have you ever been in a situation where you were building a template in Microsoft Excel 2003 and it would have been really useful to actually have a drop down list so that your users could choose from a preset list, rather than them simply typing in their own values?
This tutorial show you how to create the drop down list in Excel.

To create an Excel drop down list

Open a new Excel workbook. On the first worksheet (Sheet1) enter the following data.Cell A1 - Title
Cell B1 - Full Name

Click on the second worksheet (Sheet2) in your workbook. Enter the following data.Cell A1 - Title
Cell A2 - Mr
Cell A3 - Miss
Cell A4 - Mrs
Cell A5 - Ms

Then select the cell range A2 to A5. We are going to give a name for this range of cell.
From the Insert menu choose the Name option from the menu and click Define.

Reply With Quote
Old 01-26-2010, 11:27 AM
seema seema is offline
Join Date:
Oct 2009
Posts: 5,551

From the Define Name dialog box displayed, in the Names in workbook: text box simply type in the name Title and click the OK ****on.

Now, return to the first worksheet (Sheet1). We will create a drop down list in cell A2 so click on cell A2.

From the Data menu, click on Validation. This will open the Data Validation dialog box.

Under the Settings tab, in the Allow: drop down list, choose the List option.

In the Source: text box, typing in = Title (This is to define the name Title as the range).

To complete the process, click the OK ****on.

Return to the cell A2 and you will now see a drop down box. If you click on the arrow you will see the results from your second sheet.

Note: If you do not want your range for your list to be on the same worksheet, then you must name the range.
Reply With Quote

New topics in MS Excel 2003

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Powered by vBulletin® Version 3.8.10
Copyright ©2000 - 2019, vBulletin Solutions, Inc.