drop dpwn tables in excel

[johnny.exe]

hi, i working on a little spreadsheet and would like to insert a dro
down table, tht allows some pre-written answers to be inserted into
cell, for example : under the heading 'type of order', the correc
answerss would be 'model', 'tool' , 'base'. how do you insert drop dow
tables.
thanks
joh

 

[Pete_UK]

One 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

 

[cycling-rod]

Have a look here: http://www.meadinkent.co.uk/xldropdown.htm