I am working on a spreadsheet that has to be filled out daily. I has a large
number of columns. Much of the infomation needed to input is a choice between
three or four of the same choices. An example on a webpage is when filling
out a form and when it asks for your address, it has a button you click on to
choose which state you live in. That is what I'd like to do in Excel.
--
Thanks

Thor

Data Validation dropdown box with a list of choices.

See Debra Dalgleish's site for more on Data Validation.

http://www.contextures.on.ca/xlDataVal01.html


Gord Dibben MS Excel MVP


On Sat, 5 May 2007 13:10:00 -0700, Thor wrote:

I am working on a spreadsheet that has to be filled out daily. I has a large
number of columns. Much of the infomation needed to input is a choice between
three or four of the same choices. An example on a webpage is when filling
out a form and when it asks for your address, it has a button you click on to
choose which state you live in. That is what I'd like to do in Excel.