| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Allowing Only Certain Entrees
I am using the spreadsheet as a tracking mechanism, how do I format a cell so
it will only take a certain entry. For example, the formula is set to only count s1 or s2 or s4. If someone hits s5 one data entry, I want the cell to reject it. Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Allowing Only Certain Entrees
Data validation.
Look in Help. -- David Biddulph "George" wrote in message ... I am using the spreadsheet as a tracking mechanism, how do I format a cell so it will only take a certain entry. For example, the formula is set to only count s1 or s2 or s4. If someone hits s5 one data entry, I want the cell to reject it. Thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Allowing Only Certain Entrees
hi
click the cell which will take the input then on the menu bar... Datavalidationfollow the wizard. to learn more, on the menu bar... helptype validationclick designate valid cell entries. Regards FSt1 "George" wrote: I am using the spreadsheet as a tracking mechanism, how do I format a cell so it will only take a certain entry. For example, the formula is set to only count s1 or s2 or s4. If someone hits s5 one data entry, I want the cell to reject it. Thanks |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Allowing Only Certain Entrees
Take a look at the Validation entry in XL Help ("About setting
restrictions on cells and displaying input and error messages") In article , George wrote: I am using the spreadsheet as a tracking mechanism, how do I format a cell so it will only take a certain entry. For example, the formula is set to only count s1 or s2 or s4. If someone hits s5 one data entry, I want the cell to reject it. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Allowing a leading zero if there is one | Excel Discussion (Misc queries) | |||
| Allowing for a range using COUNTIF | Excel Worksheet Functions | |||
| Allowing only one entry in a range | New Users to Excel | |||
| Allowing Macros in Excel | Setting up and Configuration of Excel | |||
| Only Allowing Certain Codes In Column | Excel Discussion (Misc queries) | |||
Linear Mode
