Dear Vicent,
Follow the below mentioned process according to step.
1. Select Data
2. Select Validation
3. "In Allow" select List
4. and In source give the range of required data or list which you want.
*Unfeigned Regards
Manoj S Negi*
*"Miles & miles to go before I sleep"
¨`·.·´¨) Always
Go to Data -> Validation - > and select validation criteria as allow list...
_
"There are known knowns. These are things we know that we know. There are known
unknowns. That is to say, there are things
The Excel Validation feature will do what you want:
1. Select the cell(s) you want to validate.
2. On the Data menu click Validation then click the Settings tab
3. In the Allow box select List
4. Select Range containing allowed values
5. Click OK
The attached spreadsheet illustrat
Hello, Naveen.
Thank you very much for the clue. It was there, but I didn't know it.
Anyway, if the cells are modified after being used as a selection to build
the list, the "drop down list" in the target cell is also modified.
Is there any way to "fix" the list in the target cell?
Thanks.
--
Hi,
Yes it can be done using Data validation in DATA menu-->List-select source.
wil be helpful for u...
Regards
Naveen Kumar M N
Transport Supervisor(HP)
91-08-99728 10886
Email :[EMAIL PROTECTED]
Best Wishes-Karunaada Kuvara
--- On Wed, 11/19/08, Vicent Giner <[EMAIL PROTEC
