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?

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.

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.

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.