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?? |
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! |
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! |
All times are GMT +1. The time now is 07:49 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com