Board Regular

[nader]

Joined: 27 Sep 2005
Posts: 8

Flag: Blank


Status: Online

how to use the drop down list
Date: Wed, 28 Sep 2005 20:42:48 -0500
Message-ID: <[email protected]>
Organization: ExcelTip
User-Agent: ExcelTipForum
X-Newsreader: ExcelTipForum
X-Originating-IP: 213.178.253.2


how to use the drop down list
I got it from -Data | Validation | Settings- and I limite the
cells
and then the data in the cells show in the list
but I dont know how to active with worksheet, and what use the drop
down list

may example pleas


--
nader
------------------------------------------------------------------------
nader's Profile: http://www.excelforum.com/member.php...o&userid=10881
View this thread: http://www.excelforum.com/showthread...hreadid=471631

[Norman Jones]

Hi Nader,

> how to use the drop down list
> I got it from -Data | Validation | Settings- and I limite the
> cells
> and then the data in the cells show in the list
> but I dont know how to active with worksheet, and what use the drop
> down list
>
> may example pleas

Debra Dalgleish has a Data Validation tutorial at:

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


---
Regards,
Norman



"nader" <[email protected]> wrote in message
news:%[email protected]...
>
> Joined: 27 Sep 2005
> Posts: 8
>
> Flag: Blank
>
>
> Status: Online
>
> how to use the drop down list
> Date: Wed, 28 Sep 2005 20:42:48 -0500
> Message-ID: <[email protected]>
> Organization: ExcelTip
> User-Agent: ExcelTipForum
> X-Newsreader: ExcelTipForum
> X-Originating-IP: 213.178.253.2
>
>
> how to use the drop down list
> I got it from -Data | Validation | Settings- and I limite the
> cells
> and then the data in the cells show in the list
> but I dont know how to active with worksheet, and what use the drop
> down list
>
> may example pleas
>
>
> --
> nader
> ------------------------------------------------------------------------
> nader's Profile:
> http://www.excelforum.com/member.php...o&userid=10881
> View this thread: http://www.excelforum.com/showthread...hreadid=471631
>

[nader]

thankyou very mush Norman
it's wonderful site

god bless you