The Excel Drop Down List - How to Create It?
Microsoft Excel 2003 allows you to build your own Excel drop down list
Well, 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 listOpen a new Excel workbook. On the first worksheet (Sheet1) enter the following data.
Cell A1 - TitleClick on the second worksheet (Sheet2) in your workbook. Enter the following data.
Cell B1 - Full Name
Cell A1 - TitleThen 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.
Cell A2 - Mr
Cell A3 - Miss
Cell A4 - Mrs
Cell A5 - Ms
From the Define Name dialog box displayed, in the Names in workbook: text box simply type in the name Title and click the OK button. 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 button.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.
Can't find what you're looking for? Try Google Search!
Back to Top
>> Next Topic : Knowing the Excel Date and Time Functions!
<< Previous Topic : Multi-users working on the same worksheet at the same time?
You're viewing the Excel drop down list info page, click here to go back to the Home Page