Drop down menus
 

Good morning, I am operating excel 2000 and Im trying to creat drop down
menu's for a spreadsheet with employee names and such..Im not sure how to get
started

Drop down menus
 

Look at data validation--via the Data menu--Validation. Select the "list"
option and define your list. The list should be a range of the relevant
names.

Dave
--
Brevity is the soul of wit.


"Dannigirl426" wrote:

Good morning, I am operating excel 2000 and Im trying to creat drop down
menu's for a spreadsheet with employee names and such..Im not sure how to get
started

Drop down menus
 

Thanks Dave, I've done it before but just wasn't sure I was doing the right
procedure...have a great weekend

"Dave F" wrote:

Look at data validation--via the Data menu--Validation. Select the "list"
option and define your list. The list should be a range of the relevant
names.

Dave
--
Brevity is the soul of wit.


"Dannigirl426" wrote:

Good morning, I am operating excel 2000 and Im trying to creat drop down
menu's for a spreadsheet with employee names and such..Im not sure how to get
started

Drop down menus
 

And if you want to store the list of names on a different worksheet, you
can name the range, and use that name in the data validation dialog box.
There are instructions he

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

Dannigirl426 wrote:
Thanks Dave, I've done it before but just wasn't sure I was doing the right
procedure...have a great weekend

"Dave F" wrote:

Look at data validation--via the Data menu--Validation. Select the "list"
option and define your list. The list should be a range of the relevant
names.

"Dannigirl426" wrote:

Good morning, I am operating excel 2000 and Im trying to creat drop down
menu's for a spreadsheet with employee names and such..Im not sure how to get
started


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html