Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to force cell input from a List?
On Sheet1, Column B, a name must be entered. I don't want folks typing the
name, though, because spelling is important. Thus, on Sheet2 I have created a List with the names they can choose from. How do I make Columb B in Sheet1 use a drop-down for all of it's Cells, and ONLY accept input from that drop-down list? Thanks much! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to force cell input from a List?
Highlight your list of names
Go to Insert - Name - Define... Give it an easy to use name, say, Names Go to your sheet1 cells Data - Validation - choose "list" from the drop-down Type =Names Ta Da! "NightLord" wrote: On Sheet1, Column B, a name must be entered. I don't want folks typing the name, though, because spelling is important. Thus, on Sheet2 I have created a List with the names they can choose from. How do I make Columb B in Sheet1 use a drop-down for all of it's Cells, and ONLY accept input from that drop-down list? Thanks much! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to force cell input from a List?
Oh, for the love of god.
I was forgetting the equal sign. ARG! It's always the simple things. Thanks much. "Sean Timmons" wrote: Highlight your list of names Go to Insert - Name - Define... Give it an easy to use name, say, Names Go to your sheet1 cells Data - Validation - choose "list" from the drop-down Type =Names Ta Da! "NightLord" wrote: On Sheet1, Column B, a name must be entered. I don't want folks typing the name, though, because spelling is important. Thus, on Sheet2 I have created a List with the names they can choose from. How do I make Columb B in Sheet1 use a drop-down for all of it's Cells, and ONLY accept input from that drop-down list? Thanks much! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to force cell input from a List?
Can you tell me why I bothered to answer the same question in a post in
another news group? I guess because you asked to me to help you with the problem. Gord Dibben MS Excel MVP On Fri, 26 Sep 2008 13:36:03 -0700, NightLord wrote: Oh, for the love of god. I was forgetting the equal sign. ARG! It's always the simple things. Thanks much. "Sean Timmons" wrote: Highlight your list of names Go to Insert - Name - Define... Give it an easy to use name, say, Names Go to your sheet1 cells Data - Validation - choose "list" from the drop-down Type =Names Ta Da! "NightLord" wrote: On Sheet1, Column B, a name must be entered. I don't want folks typing the name, though, because spelling is important. Thus, on Sheet2 I have created a List with the names they can choose from. How do I make Columb B in Sheet1 use a drop-down for all of it's Cells, and ONLY accept input from that drop-down list? Thanks much! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to get cell input to access list? | New Users to Excel | |||
How can I input an ordered or bulleted list in a XL cell | Excel Discussion (Misc queries) | |||
data validation list: how do i 'force' a user to enter data from the list? | Excel Discussion (Misc queries) | |||
data validation list: how do i 'force' a user to enter data from the list? | Excel Discussion (Misc queries) | |||
How to force a Default sort for a validation list | Excel Discussion (Misc queries) |