Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Data Validation - List in Excel 97
- Thread starter Llwynog
- Start date
AnotherHiggins
Technical User
Assign a name to the range containing the items to be included in the list.
Example:
On Sheet2, you have a list in column A.
[ul][li]select Column A (or just the portion containing the list)[/li]
[li]Go to Insert > Name > Define[/li]
[li]Change the Name at the top to something like MyList[/li]
[li]Back on Sheet1, highlight the range on which you want to use validation[/li]
[li]Go to Data > Validation[/li]
[li]Change the 'Allow' to List[/li]
[li]In 'Source', enter =MyList[/li][/ul]
That's it!
[tt]_____
[blue]-John[/blue]
[/tt][red]"If you're flammable and have legs, you are never blocking a fire exit."[/red]
-Mitch Hedberg
Help us help you. Please read FAQ181-2886 before posting.
Example:
On Sheet2, you have a list in column A.
[ul][li]select Column A (or just the portion containing the list)[/li]
[li]Go to Insert > Name > Define[/li]
[li]Change the Name at the top to something like MyList[/li]
[li]Back on Sheet1, highlight the range on which you want to use validation[/li]
[li]Go to Data > Validation[/li]
[li]Change the 'Allow' to List[/li]
[li]In 'Source', enter =MyList[/li][/ul]
That's it!
[tt]_____
[blue]-John[/blue]
[/tt][red]"If you're flammable and have legs, you are never blocking a fire exit."[/red]
-Mitch Hedberg
Help us help you. Please read FAQ181-2886 before posting.
- Status
