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.

press Alt+Enter to see/enter more characters

Kaylen wrote:

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.

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.

"Bob I" wrote:

press Alt+Enter to see/enter more characters

Kaylen wrote:

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.

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.

Kaylen wrote:
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.

"Bob I" wrote:


press Alt+Enter to see/enter more characters

Kaylen wrote:


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.

HelpSpecifications 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

On Thu, 23 Oct 2008 08:44:01 -0700, Kaylen
wrote:

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.