Drop down selections

T

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?
 
B

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?
Click to expand...
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.
 
Top