| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Restrict data entry in a cell
Hi,
I would like to ensure that a user can only input one of the following numbers in a cell: 1, 2, 3, 4, 5, 6, 7 or 10 I'm using Excel 2003. Thank you Ephraim |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Restrict data entry in a cell
Data/Validation
select List enter: 1,2,3,4,5,6,7,10 Click OK. You're done. Bob Umlas Excel MVP "Ephraim" wrote in message ... Hi, I would like to ensure that a user can only input one of the following numbers in a cell: 1, 2, 3, 4, 5, 6, 7 or 10 I'm using Excel 2003. Thank you Ephraim |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Restrict data entry in a cell
On Mar 18, 4:30*pm, "Bob Umlas" wrote:
Data/Validation select List enter: 1,2,3,4,5,6,7,10 Click OK. You're done. Bob Umlas Excel MVP "Ephraim" wrote in message ... Hi, I would like to ensure that a user can only input one of the following numbers in a cell: 1, 2, 3, 4, 5, 6, 7 or 10 I'm using Excel 2003. Thank you Ephraim- Hide quoted text - - Show quoted text - Is there a way to do it without using a dropdown list? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Restrict data entry in a cell
Is there a way to do it without using a dropdown list?
Follow Bob's instructions but *uncheck* In-cell drop down. -- Biff Microsoft Excel MVP "Ephraim" wrote in message ... On Mar 18, 4:30 pm, "Bob Umlas" wrote: Data/Validation select List enter: 1,2,3,4,5,6,7,10 Click OK. You're done. Bob Umlas Excel MVP "Ephraim" wrote in message ... Hi, I would like to ensure that a user can only input one of the following numbers in a cell: 1, 2, 3, 4, 5, 6, 7 or 10 I'm using Excel 2003. Thank you Ephraim- Hide quoted text - - Show quoted text - Is there a way to do it without using a dropdown list? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Restrict data entry to specified cells | Excel Worksheet Functions | |||
| How do I restrict data entry to one of two columns but not both? | Excel Discussion (Misc queries) | |||
| lock cell conditional format but not restrict data entry | Excel Worksheet Functions | |||
| How can I restrict a cell(s) to alpha-only data entry? | Excel Discussion (Misc queries) | |||
| can i restrict data entry from certain columns | Excel Discussion (Misc queries) | |||
Linear Mode
