How do I create a drop down list box?

[Leslie_Gray]

Version: 2008 Operating System: Mac OS X 10.0 (Cheetah) I am creating a form and need to create a drop down list box. It is very unclear how to do this. Thank you.

 

[Michel Bintener]

Hi,

for the drop down box to work, you need to format your spreadsheet as a
list. To do that, select your data, then click on Insert>List. Follow
the steps provided by the List wizard and create the list. Type the text
you would like to have in that drop down box in individual cells
*outside the list*. Then place the cursor inside the newly created list,
in the column that you want to appear as a drop down box, then click on
the Column Settings button on the List toolbar.

In the dialogue that shows up, select List as the data type, then click
on the tiny icon to the right of the source field to select the cells
that contain the drop down list items. Once you have done so, click on
OK, and the column should now have turned into a drop down box.

 

[Leslie_Gray]

Hi,

>
> for the drop down box to work, you need to format your spreadsheet as a
> list. To do that, select your data, then click on Insert>List. Follow
> the steps provided by the List wizard and create the list. Type the text
> you would like to have in that drop down box in individual cells
> *outside the list*. Then place the cursor inside the newly created list,
> in the column that you want to appear as a drop down box, then click on
> the Column Settings button on the List toolbar.
>
> In the dialogue that shows up, select List as the data type, then click
> on the tiny icon to the right of the source field to select the cells
> that contain the drop down list items. Once you have done so, click on
> OK, and the column should now have turned into a drop down box.
>

>
> --
> Michel Bintener
> Microsoft MVP (Macintosh)
>
> *** Please always reply to the newsgroup. ***
> Thank you. Really what I needed was under validation. Thanks