drop dpwn tables in excel

  • Thread starter Thread starter johnny.exe
  • Start date Start date
J

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
 
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
 
Back
Top