Cell Display Limit

[Chris A Wood]

Hi,

In Excel 2003, my file will not display on the screen all of the characters in one of the cells. I have read the character limit is 1,024. Is there any way to increase this limit to display more?

Thanks,

Chris

 

[RoryA]

You can break the text up with line feeds (Alt+Enter) but if you have a lot of text you may run up against the maximum row height at some point.

 

[Richard Schollar]

Hi Chris

Depending on the font and size settings you are using you can actually get more than 1024 to display (may depend on Zoom settings too) - but this is only going to tweak the 1024 (eg you mighgt get 1200 to show). If you need more then either consider using a texbox or a different program (!).

 

[Chris A Wood]

Thanks for the tip on Alt Enter - That is helping.

Also, thanks for the tip on tweaking some settings.

I'll see how much data I can get in!

 

[lenze]

Not that I know, but I could be wrong. I'm lazy and would never consider a cell length that long. But you might be able to show the overflow in an adjacent cell

=If(LEN(A1)>1024,RIGHT(A1),LEN(A1)-1024)

or in a Comment

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count > 1 Then Exit Sub
If Target.Column <> 1 Then Exit Sub
If Len(Target) > 1024 Then
    Target.ClearComments
    Target.AddComment.Text Text:=Right(Target, Len(Target) - 1024)
End If
End Sub

lenze

 

[Chris A Wood]

Some good code to use. It is actually not my spreadsheet - it is my boss's. But hopefully we can use these hints to make it work!

Thanks!