| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Prevent data from typing in another cell in a saved template?
I have saved a template and when I enter data it merges into the next column.
Is there a way to locke the cells where only x amount of info can be entered into that cell? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Prevent data from typing in another cell in a saved template?
Puzzlesolver wrote:
I have saved a template and when I enter data it merges into the next column. Is there a way to locke the cells where only x amount of info can be entered into that cell? Try this... Data / Validation / Settings / Validations Criteria / Allow: / Text Length. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Prevent data from typing in another cell in a saved template?
Please give me an example of expression for the text lenght.
Thanks "Glenn" wrote: Puzzlesolver wrote: I have saved a template and when I enter data it merges into the next column. Is there a way to locke the cells where only x amount of info can be entered into that cell? Try this... Data / Validation / Settings / Validations Criteria / Allow: / Text Length. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Prevent data from typing in another cell in a saved template?
Puzzlesolver wrote:
I have saved a template and when I enter data it merges into the next column. Is there a way to locke the cells where only x amount of info can be entered into that cell? "Glenn" wrote: Try this... Data / Validation / Settings / Validations Criteria / Allow: / Text Length. Puzzlesolver wrote: Please give me an example of expression for the text lenght. Thanks Well, you could set "Data:" to "less than" and put this in the "Maximum:" field: =CELL("width") That might work OK for fixed width fonts. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| prevent a cell from having data add with out another celled filled | Excel Discussion (Misc queries) | |||
| How do I prevent data from being entered into a particular cell? | Excel Discussion (Misc queries) | |||
| Prevent cell data from converting to euros | Excel Discussion (Misc queries) | |||
| prevent data entry into cell? | Excel Worksheet Functions | |||
| How do I prevent Hyperlinks from changing when saved? | Excel Discussion (Misc queries) | |||
Linear Mode
