Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
limiting text entry into columns
Is it possible for me to set-up a spreadsheet for others to use but will
limit the options of the data that they can enter (text only), so that they may only chose from a list which they can check more than one option (similar to the filter function), this would be similar to how e-cert works?? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
limiting text entry into columns
"tobypitblado" wrote: Is it possible for me to set-up a spreadsheet for others to use but will limit the options of the data that they can enter (text only), so that they may only chose from a list which they can check more than one option (similar to the filter function), this would be similar to how e-cert works?? Data Validation is what you want to use, from drop downs (or tabs in 2007), go to Data, then validation (or Data Validation in 2007). From there you should be able to follow the rest without problem. Hope this helps! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
limiting text entry into columns
Yes this helped, Thanks Pete
"Pete Ross" wrote: "tobypitblado" wrote: Is it possible for me to set-up a spreadsheet for others to use but will limit the options of the data that they can enter (text only), so that they may only chose from a list which they can check more than one option (similar to the filter function), this would be similar to how e-cert works?? Data Validation is what you want to use, from drop downs (or tabs in 2007), go to Data, then validation (or Data Validation in 2007). From there you should be able to follow the rest without problem. Hope this helps! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
limiting text entry of columns | Excel Discussion (Misc queries) | |||
limiting data entry cells | Excel Discussion (Misc queries) | |||
Limiting physical length of text in a text box control | Excel Discussion (Misc queries) | |||
limiting combo box entry | Excel Worksheet Functions | |||
Limiting text | Excel Programming |