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

Calculate the median value before a specified list 0
Find text in cell and copy from 4 characters in front of the found text. 2
How to bulk add section breaks after a particular combination of letters/numbers 0
text exceeds allowed number of characters per cell 1
Counting characters 3
Cell Formats - Limit # of characters 5
No. of characters in an Excel column 2
Crating User Form to Add Names 1

Top