Is it possible to enter more than 255 characters in a cell

D

Dajana

Is it possible to have more than 255 characters in a cell. I know that the
limit is 1024 but I want to be able to see and print all of the characters.

Thanks
Dajana
 
P

Paul B

Dajana, I think it will work if you manually enter some line breaks in the
text with ALT+Enter
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
D

Dave Peterson

The limit is 32767, actually.

But you'll only see about 1000 characters unless you add alt-enters (to force a
new line within the cell) every 80-100 characters.

(Well, xl95 does have a limit of 255 characters per cell, but xl97 increased it
to 32767.)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I get more than 255 characters into a cell? 3
How can I copy more than 255 characters in a cell without truncati 1
Why can't I get more than 255 characters in one cell in Excel 07? 1
Custom filter limit removed in 2007? 1
Microsoft Excel Cell text limits 3
Custom list 255 character limit too small 1
Multiple templates with common styles 2
Excel does not accept text format! 0

Top