Excel Issue

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Derek - 30 Apr 2004 17:02 GMT

Is there a way in Excel to limit the amount of text that
can typed in defined area? For example, lets say I have
10 columns by 5 rows and I want users to type a
description in this area but I don't want them to type
past the 5th row. I want it to automtically stop so they
can't type anymore. Is this possible?? Thanks!!

Reply to this Message

Charlie - 30 Apr 2004 18:48 GMT

Derek,

One way would be to protect the worksheet.
Format/Cells/Protection and Unlock the cells that require
data. Then go to Tools/Protection/Protect sheet.

Charlie O'Neill

>-----Original Message-----
>Is there a way in Excel to limit the amount of text that
[quoted text clipped - 5 lines]
>
>.

Reply to this Message

Derek - 30 Apr 2004 19:10 GMT

Charlie,

That didn't seem to work.

>-----Original Message-----
>Derek,
[quoted text clipped - 15 lines]
>>
>.

Reply to this Message

Anders S - 30 Apr 2004 23:57 GMT

As long as the user is typing in the cell there is AFAIK no way to limit the
amount of text entered.
However, once the user hits Enter you can use Data>Validation to verify that the
entered text is within limits.
I don't understand what you mean by "I don't want them to type past the 5th row"

Regards
Anders Silven

> Is there a way in Excel to limit the amount of text that
> can typed in defined area? For example, lets say I have
> 10 columns by 5 rows and I want users to type a
> description in this area but I don't want them to type
> past the 5th row. I want it to automtically stop so they
> can't type anymore. Is this possible?? Thanks!!

Reply to this Message

Rate this thread: