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.
Microsoft MVP (Macintosh)
*** Please always reply to the newsgroup. ***