Dropdowns

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

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)

--
Andy.


"Janice" wrote in message
...
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

janice,

You will need to set up a list say in F1 to Fwhatever with :water, lightning, roof,
hail, etc

Then in the cell(s) you require the drop down , go:

Data
Validation
Allow = List
Source F1: F whatever then Ok

Harry

"Janice" wrote:

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

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!
==============================================

"Janice" wrote in message
...
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

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.

Janice wrote:
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.

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html