Drop down selections

[TREBORA]

Version: 2004
Operating System: Mac OS X 10.4 (Tiger)
Processor: Power PC

I have seen spreadsheets where the user has created a drop down list from which one item can selected to create an entry. How is this created?

 

[Bob Greenblatt]

Version: 2004
Operating System: Mac OS X 10.4 (Tiger)
Processor: Power PC

I have seen spreadsheets where the user has created a drop down list from
which one item can selected to create an entry. How is this created?

One way is to use data validation. Select it from the menu, then choose
list. Type in the valid entries, or as reference to a range containing the
entries.