Drop Down List

S

sue

Hi I need to create a pick list in a spreadsheet.

For example: In cell B7, I want to give the user the
option to enter: Apples, Oranges or Pears. I need to
provide them with a pick list and depending on what they
select, the answer will appear in cell B7. I am pretty
new to excel and am not sure how to tackle this. I have
looked at the Forms toolbar and used the combo box but I
am now stuck.

Please help. Thanking you in advance.
Sue
 
D

Don Guillett

Just make a list somewhere and right click on the combobox>select format
control>select control
Refer to your range list
etc
 
S

Squid

Make sure you are in design mode. Use the combo box in
the control toolbox toolbar.

Select the combo box, then Right click on the combo box
and select properties.

In the ListFillRange enter the range where your Apples,
Oranges, Pears is listed. i.e. A1:A3

In the LinkedCell enter B7. This is where the result of
the selection in the combo box will appear.


Is this what you had it mind?
 
D

Dave Peterson

Put the list somewhere else (on another worksheet??) and make the cell with
Data|Validation B7?????
 
Top