Prevent data from typing in another cell in a saved template?

  • Thread starter Thread starter Puzzlesolver
  • Start date Start date
P

Puzzlesolver

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?
 
Puzzlesolver said:
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?
Click to expand...


Try this...

Data / Validation / Settings / Validations Criteria / Allow: / Text Length.
 
Puzzlesolver said:
Puzzlesolver wrote:
Please give me an example of expression for the text lenght.
Thanks
Click to expand...


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.
 
Back
Top