Max cell height for text

  • Thread starter Thread starter Russ Lipp
  • Start date Start date
R

Russ Lipp

We need to insert text from a Word document into a cell.
The text is about 300 words. After we do the insert, we
can only see a portion of the text in the cell. We tried
stretching the row boundary, but it stopped stretching
towards the bottom of the window. Even the print image
doesn't show all the text. How can we increase the cell
height to see all the text?
 
Normally pasting into the formula bar the row will cause it to fit
automatically but you could try Format>Row>Auto fit, ...then the same with
column if needed, but one wonders why you would want to do that as it would
stretch the row/column so far that adjacent cells would most likely be off
the screen for viewing.

Rob
 
Russ

From Help.... Excel allows 32,767 characters in a cell but will show or print
only 1024(see Help>Specifications).

One workaround is to spread a few ALT + ENTER's at spots. This will increase
the amount shown. Don't know how far this will go.

Before you take Help or my suggestion literally you may find some
enlightenment regarding the limitations of text in a cell in this google
search result.

http://snurl.com/26vl

Gord Dibben Excel MVP
 
You can spread it over several cells by selecting the cell containing the
text and one or more of the cells below it, and then using the Edit > Fill >
Justify menu option.
 
In addition to the maximum number of characters per cell, there is a maximum
row height of 409 points (in Excel 2000 at least).

Jay
 
Back
Top