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 here:

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 here:
>
> 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 (Insert>Name>Define
Name...), or the INDIRECT function (INDIRECT("Sheet1!A1:A10))

--

HTH

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


"Sir Paul" <[email protected]> wrote in message
news:[email protected]...
> 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 here:
> >
> > 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
Insert>Name>Define.

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"
<[email protected]> 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 here:
>>
>> 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
> Insert>Name>Define.
>
> 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"
> <[email protected]> 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 here:
> >>
> >> 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
> >>
> >>
>
>