View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Glenn Glenn is offline
external usenet poster
 
Posts: 1,240
Default 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.