Cell limit of characters

K

Kaylen

Is there a way for Excel to allow a cell or a column of cells to have more
than 250 characters? I am creating a form that has a comment section.
Sometime when a comment is lengthy and exceed 250 characters, excel only
shows the first 250 characters and cut off the rest (both on screen and when
printed). Is there a way to allow a cell to show 250+ characters?

Any help is apprecited. Thank you.
 
K

Kaylen

The problem is not being able to see all the text on screen. The problem is
not seeing completely whole in print preview or when printed. The cell cut
off after 250 characters on print preview and so when printed as well.

Thank you for your effort. I hope there is a way to allow a cell to show in
print more than 250 characters.
 
B

Bob I

Is the cell large enough to display? As a test I just printed a cell
with 594 characters and none are missing. Again, I say, add Alt+Enters.
 
G

Gord Dibben

Help>Specifications states

You can enter 32767 characters in a cell but only 1024 of those will be
visible or can be printed. The formula bar will show all characters.

How are you entering the data that limits you to 250 characters?

How did you determine that you are seeing only 250 characters?


Gord Dibben MS Excel MVP
 

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

text exceeds allowed number of characters per cell 1
No. of characters in an Excel column 2
Counting characters 3
Line lenght limit while saving as a PRN file 4
Cell Formats - Limit # of characters 3
limit number of characters in cell 4
Total Cell Characters Count 1
How to limit the number of characters in a cell? 5

Top