Excel 2003 Tips - Create List in Excel (Basic)

Normally there are 2 ways to create list in Excel that I use.
My first blog starting with the easy way :)

Here is what I want...
I can select a value from Dropdownlist only.

Ok, let's start on how to create above list step-by-step.

1. You have to prepare the value in Dropdownlist first. Just type all List values you have.



2. Select entire cell that you want to place Dropdownlist, my sample image use Column B as target cell. Then go to Data Menu, select Validation...

3. At Data Validation windows, select Validation criteria Allow List and define Source to the list values you prepared, then click OK.

4. Finished!!, you can do it :)

in this way, list can use only in the same sheet with data source.
Next post, I will describe how to create a list that can share to entire workbook.