excel - drop boxes

  • Thread starter Thread starter don
  • Start date Start date
D

don

I am trying to figure our how to create a drop box with
multiple values - i.e. january, february, march...

Something like a box that says "choose month" in the box
and when you hit the arrow it allows you to scroll
through the monthly options and choose one.

I am currently using Excel 2000.

I WOULD BE VERY GREATFUL if someone could offer me a
prompt response. Thank you
 
Data / Validation / Change 'Any Value' to list and then select the list containing the values you
wish to choose from, or instead of selecting a list, type Jan,Feb,Mar,Apr,May etc (including
commas) into the box marked 'source' at the bottom of the dialog box.
 
Have you done the "Validation" thing? Click on the cell you want this
in, the go to the data menu at the top and click on validation. There
are a couple of way to do it. Under the "allow" heading click on List.
Then enter the months in the "source" box. Seperate each month by a
comma. When finished, the cell you were in will have a drop down menu
in it. You can highlight numerous cells or whole columns and do the
same thing. Go to help and read up on validations, there are other
methods as well such as making lists elsewhere, naming them and
refering to those lists in the validation thing.

Hope this helps. I use it all the time. I would be happy to send you
and example spreadsheet if you desire.

Doc Cowher
 
Debra Dalgleish's web page should show you all you need to know to
accomplish this.

http://www.contextures.com/xlDataVal01.html
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



I am trying to figure our how to create a drop box with
multiple values - i.e. january, february, march...

Something like a box that says "choose month" in the box
and when you hit the arrow it allows you to scroll
through the monthly options and choose one.

I am currently using Excel 2000.

I WOULD BE VERY GREATFUL if someone could offer me a
prompt response. Thank you
 
Back
Top