creating drop down lists

[bindo]

is there any way that i can format a cell so that when
clicked a drop down lst appears with a list of possible
destinations for data from a specified cell?

 

[Andy B]

bindo

Have a look here:

http://www.contextures.com/xlDataVal01.html

Andy.

 

[Frank Kabel]

Hi
have a look at data validation (menu: 'Data - Validation). See
http://www.contextures.com/xlDataVal01.html
for some starting information