Max cell height for text

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?
 
R

rob nobel

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
 
G

Gord Dibben

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
 
H

HONYAKUKA

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
 

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 to paste this down? 3
Move Chart with Text 0
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
Creating Labels Over 3-Up Image 2
Formatting issues with Excel sheet in email body 0
Setting rows to autofit wrapping text in a cell 1
Auto Cell Height Adjustment for text entered 3
Table Preferred width is changed when pasting 1

Top