Can you Limit the number of caracters that can be typed in a cell?
 

How would I go About limiting the numbers of characters that can b
typed into a cell.

The idea behind it is to keep cells from "overflowing" if name type
into it happens to be bigger than the cell itself.

Yes, space is limited...

Thank you very much;

--
Message posted from http://www.ExcelForum.com

Can you Limit the number of caracters that can be typed in a cell?
 

Look at Data=Validation, text length

--
Regards,
Tom Ogilvy

"pepperjack " wrote in message
...
How would I go About limiting the numbers of characters that can be
typed into a cell.

The idea behind it is to keep cells from "overflowing" if name typed
into it happens to be bigger than the cell itself.

Yes, space is limited...

Thank you very much;)


---
Message posted from http://www.ExcelForum.com/

Can you Limit the number of caracters that can be typed in a cell?
 

Thanx Tom. What about the sheet's character lenght? Can it be done a
well

--
Message posted from http://www.ExcelForum.com

Can you Limit the number of caracters that can be typed in a cell?
 

To the best of my knowledge, the sheet name (name on the tab) is limited to
31 or 32 characters. There is no other way to limit it other than write
code to change it to something shorter. Other than that, I don't know what
you are talking about.

--
Regards,
Tom Ogilvy

"pepperjack " wrote in message
...
Thanx Tom. What about the sheet's character lenght? Can it be done as
well?


---
Message posted from http://www.ExcelForum.com/