Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
drop down menus | Excel Discussion (Misc queries) | |||
formulas for drop down menus | Excel Discussion (Misc queries) | |||
how do I insert drop down menus into excel that are dependent on . | Excel Discussion (Misc queries) | |||
Drop Down Menu's | Excel Discussion (Misc queries) | |||
Drop down menus | Excel Discussion (Misc queries) |