Drop-down boxes

  • Thread starter Thread starter KRK
  • Start date Start date
K

KRK

Hello,

I want to enter text into a cell, with the text chosen from a limited number
of options (probably listed in a separate sheet). I suspect I need a
'drop-down box' ??. Do I need to write VBA code, or is this built into Excel
?

At this stage all I need is to know how difficult it's going to be .

I have Excell 2007

Thanks

K
 
Use Data Validation. Select "List" from the options and with the Red button
minimise, go to wherever your list is there, select all of it. That's it. In
that cell you get full list to choose from. Copy this format to all cells or
previously select all cells and then go to data validation. Hope this helps
 
Back
Top