| 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) | |||
Linear Mode
