Drop Down menu in a Cell
 

It is possible to create a drop down menu in a cell?
I would like to make spreadsheet with a number of these cells.
What is the proper name for doing this procedure?

TIA
Eric

Drop Down menu in a Cell
 

Use Data ==List == Create List...

Sandy

Window Guy wrote:
It is possible to create a drop down menu in a cell?
I would like to make spreadsheet with a number of these cells.
What is the proper name for doing this procedure?

TIA
Eric

Drop Down menu in a Cell
 

Thank you Sandy,

I'm using Excel 2002 ver - that menu choice is not there?
I have 2003 at home - Is that something that has just been added?

Thanks,
eric

"Sandy" wrote in message
ups.com...
Use Data ==List == Create List...

Sandy

Window Guy wrote:
It is possible to create a drop down menu in a cell?
I would like to make spreadsheet with a number of these cells.
What is the proper name for doing this procedure?

TIA
Eric

Drop Down menu in a Cell
 

Hi,
Use Menu Data/Validation and then select a list etc.

"Window Guy" wrote:

It is possible to create a drop down menu in a cell?
I would like to make spreadsheet with a number of these cells.
What is the proper name for doing this procedure?

TIA
Eric

Drop Down menu in a Cell
 

Try view toolbars control toolbox

You'll probably want a "combo box"

Right clicking provides you several properties. Use ListFillRange for
starters.

Sincerely,

Christmas May


"Window Guy" wrote:

Thank you Sandy,

I'm using Excel 2002 ver - that menu choice is not there?
I have 2003 at home - Is that something that has just been added?

Thanks,
eric

"Sandy" wrote in message
ups.com...
Use Data ==List == Create List...

Sandy

Window Guy wrote:
It is possible to create a drop down menu in a cell?
I would like to make spreadsheet with a number of these cells.
What is the proper name for doing this procedure?

TIA
Eric

Drop Down menu in a Cell
 

xl2003 added data|list.

But I'd try data|validation before using a combobox. Data|validation is usually
a lot simpler to implement.

See Debra Dalgleish's site for a bunch of instructions:
http://www.contextures.com/xlDataVal01.html

Window Guy wrote:

Thank you Sandy,

I'm using Excel 2002 ver - that menu choice is not there?
I have 2003 at home - Is that something that has just been added?

Thanks,
eric

"Sandy" wrote in message
ups.com...
Use Data ==List == Create List...

Sandy

Window Guy wrote:
It is possible to create a drop down menu in a cell?
I would like to make spreadsheet with a number of these cells.
What is the proper name for doing this procedure?

TIA
Eric



--

Dave Peterson

Drop Down menu in a Cell
 

What Dave said...



Window Guy wrote:
Thank you Sandy,

I'm using Excel 2002 ver - that menu choice is not there?
I have 2003 at home - Is that something that has just been added?

Thanks,
eric

"Sandy" wrote in message
ups.com...
Use Data ==List == Create List...

Sandy

Window Guy wrote:
It is possible to create a drop down menu in a cell?
I would like to make spreadsheet with a number of these cells.
What is the proper name for doing this procedure?

TIA
Eric