J
Joe
How do you create a drop down list in excel? anyone.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
L
Lise
Validation, uder Allow chose list and in Source enter the-----Original Message-----
How do you create a drop down list in excel? anyone.
.
Select the cell you want it to appear in, go to Data,
items you want listed in the drop down menu.
Lise
T
Tod
There are a couple ways to do this. If you want a quick
and dirty method of just choosing from a list of values
that are already in the column, you can use a built-in
feature called 'Pick from List'. Just right click in a
cell and choose Pick from List.
Another solution is to choose the Combo Box from the
Contorl Toolbox toolbar. Once drawn, choose the properties
by right clicking on the combo box. For ListFillRange, put
the worksheet range for the list of values you want to
appear. Click the Design Mode icon on the toolbar. Now
when you pull down the combo box, you'll see your values
listed there.
tod
and dirty method of just choosing from a list of values
that are already in the column, you can use a built-in
feature called 'Pick from List'. Just right click in a
cell and choose Pick from List.
Another solution is to choose the Combo Box from the
Contorl Toolbox toolbar. Once drawn, choose the properties
by right clicking on the combo box. For ListFillRange, put
the worksheet range for the list of values you want to
appear. Click the Design Mode icon on the toolbar. Now
when you pull down the combo box, you'll see your values
listed there.
tod
F