Dropdown menu
 

Is there a way to make a custom dropdown list for a column or group of cells?

You can use Data Validation to create dropdown lists in cells. There are
instructions in Excel's Help, and he

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


ghost1967 wrote:
Is there a way to make a custom dropdown list for a column or group of cells?


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

Data Validation is the way to go, use it regularily.

Ensure that you list criteria of what must appear on the pull down is
somewhere on your sheet, I have yet to find a way where I can have a master
sheet with all my detail.

"Debra Dalgleish" wrote:

You can use Data Validation to create dropdown lists in cells. There are
instructions in Excel's Help, and he

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


ghost1967 wrote:
Is there a way to make a custom dropdown list for a column or group of cells?


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

You can refer to another sheet if you use named ranges (InsertNameDefine
Name...), or the INDIRECT function (INDIRECT("Sheet1!A1:A10))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Sir Paul" wrote in message
...
Data Validation is the way to go, use it regularily.

Ensure that you list criteria of what must appear on the pull down is
somewhere on your sheet, I have yet to find a way where I can have a
master
sheet with all my detail.

"Debra Dalgleish" wrote:

You can use Data Validation to create dropdown lists in cells. There are
instructions in Excel's Help, and he

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


ghost1967 wrote:
Is there a way to make a custom dropdown list for a column or group of
cells?


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

Sir Paul

Lists don't have to be on the sheet.

Have the lists on your Master sheet and give them Names from
InsertNameDefine.

Use the Name in your DV source dialog box.

i.e. =MyList


Gord Dibben Excel MVP

On Mon, 10 Jan 2005 21:05:02 -0800, "Sir Paul"
wrote:

Data Validation is the way to go, use it regularily.

Ensure that you list criteria of what must appear on the pull down is
somewhere on your sheet, I have yet to find a way where I can have a master
sheet with all my detail.

"Debra Dalgleish" wrote:

You can use Data Validation to create dropdown lists in cells. There are
instructions in Excel's Help, and he

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


ghost1967 wrote:
Is there a way to make a custom dropdown list for a column or group of cells?


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

WOW guys, thanks, this will make my sheets easier and with faster files too,
not so much detail to carry on each of my 20 sheets, in total I had 90 names
in three different lists per sheet,

thanks

"Gord Dibben" wrote:

Sir Paul

Lists don't have to be on the sheet.

Have the lists on your Master sheet and give them Names from
InsertNameDefine.

Use the Name in your DV source dialog box.

i.e. =MyList


Gord Dibben Excel MVP

On Mon, 10 Jan 2005 21:05:02 -0800, "Sir Paul"
wrote:

Data Validation is the way to go, use it regularily.

Ensure that you list criteria of what must appear on the pull down is
somewhere on your sheet, I have yet to find a way where I can have a master
sheet with all my detail.

"Debra Dalgleish" wrote:

You can use Data Validation to create dropdown lists in cells. There are
instructions in Excel's Help, and he

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


ghost1967 wrote:
Is there a way to make a custom dropdown list for a column or group of cells?


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