Drop-down boxes

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
 
D

dindigul

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word Lock specific drop downs on a Word Document 0
Excel 2003 Drop Down Box 2
excel drop down list 4
Drop Down List 20
Drop down menu formatting 2
Restrict Choice in Shared WB (drop down alternative)? 0
Alt codes 4
Outlook from .dotx to .oft 1

Top