software

hi, i working on a little spreadsheet and would like to insert a drop
down table, tht allows some pre-written answers to be inserted into a
cell, for example : under the heading 'type of order', the correct
answerss would be 'model', 'tool' , 'base'. how do you insert drop down
tables.
thanks
john--
johnny.exe
------------------------------------------------------------------------
johnny.exe's Profile: www.excelforum.com/member.php...oamp;userid=30775
View this thread: www.excelforum.com/showthread...hreadid=517727One way is to use Data Validation - here you can define a list of
acceptable responses and specify that you want the entries in the cell
where you have DV to choose from this list.

Hope this helps.

Pete
Have a look he www.meadinkent.co.uk/xldropdown.htm--
cycling-rod
------------------------------------------------------------------------
cycling-rod's Profile: www.excelforum.com/member.php...oamp;userid=13520
View this thread: www.excelforum.com/showthread...hreadid=517727