If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Fixed cell width
Is there a way to set maximum 30 characters in a cell?
E.g., when 30 characters were typed, it will not allow more text be typed in that cell. |
#2
|
|||
|
|||
Fixed cell width
Hi
No. Absolutely nothing happens in Excel when you write things into cells. All such things must take place after each entry is totally completed. -- HTH. Best wishes Harald Followup to newsgroup only please. "Need Help" wrote in message ... Is there a way to set maximum 30 characters in a cell? E.g., when 30 characters were typed, it will not allow more text be typed in that cell. |
#3
|
|||
|
|||
Fixed cell width
You can use Data Validation to do this. Select the cell, and choose
Validation from the Data menu. In the Allow list, choose Text Length, and enter the minimum and maximum allowable lengths. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Need Help" wrote in message ... Is there a way to set maximum 30 characters in a cell? E.g., when 30 characters were typed, it will not allow more text be typed in that cell. |
Thread Tools | |
Display Modes | |
|
|