Drop-down list in Microsoft Excel
Sunday, April 8th, 2007Create a drop-down list in Microsoft Excel is easy.
Along with this, I give you an example.
First, type the names below in the A column from cell A1 to cell A5:
Ari
John
Klark
Michael
Patric
I assume that we will create a drop-down list in cell C1.
The step that you should do:
On the Data menu, click Validation, and then click the Settings tab.
In the Allow box, click List.
Click the Source box and block cell A1 until A5 then clik Ok
See the result below:
