Dropdowns

J

Janice

I am using Office 2000 on a windows 2000 machine.

Can you tell me how to create a dropdown with choices
for a cell.

I want to put choices such as water, lightning, roof,
hail, etc. in addition to having a dropdown to open i
would like the option of just typing in the first letter
and having a choice come up.

thank you
janice
 
A

Andy B

Hi

You are looking for Data / Validation. Using this you can set ceratin
criteria (whole numbe, date, time etc) or you create a list (or use an
existing one)
 
R

RagDyeR

Debra Dalgleish has a web page(s) that has all the info you need to get
started on this.

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

HTH,

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

I am using Office 2000 on a windows 2000 machine.

Can you tell me how to create a dropdown with choices
for a cell.

I want to put choices such as water, lightning, roof,
hail, etc. in addition to having a dropdown to open i
would like the option of just typing in the first letter
and having a choice come up.

thank you
janice
 
D

Debra Dalgleish

Others have suggested Data Validation to create a dropdown list of
choices for a cell.

However, you'll have to scroll through the list, and select the item for
the cell. It won't autocomplete as you start typing the letters.

A combobox from the Control toolbox has that feature, but may be a bit
more difficult to set up.
 
Top