microsoft.excel.courses.in.london - Drop down lists

Dear Jason

Thanks you for attending Excel Intermediate and Project training.

Creating dropdown list in Excel is quiet simple than it seems. Please follow these steps:

Step1: Select the cells that you want the drop down lists in.
Step 2: Choose Data > Validation... from the menu bar
Step 3: In the Validation Criteria section, from the Allow: Choose "List"
Step 4: Once you have done that Source section should appear. Type your list, in your case, type Red, Amber, Green

NB: You have to separate your choices by putting, (comma).

If you have entered the value somewhere else on the same worksheet then you are allowed to select those cells rather than typing the entries manually. But please be aware that it you or somebody else deletes that column then the data in eth list will be deleted as well.

Another important thing to note here is that if you have a lot of information to enter as your list it would be better to type it out in Word using commas. Then you can simply use the shortcut commands Ctrl+C to copy in Word and come to Excel and in the data Validation dialog box in the source box use CTRL+ V to paste. This is particularly helpful if you already have information in the source box in the Data validation and you are trying to add extra data to your lists.

Hope this helps!!

Kindest Regards

Rajeev Rawat
MOS Master Instructor 2000 and 2003