Max size of cell

[Russ Lipp]

We have a speadsheet in which we are trying to load all
the text from a Word document - about 300 words. The text
goes into the cell, but we cannot see the last portion in
the cell or the print image. We have tried stretching the
row boundary, but that seems to only stretch so far, and
then it stops. How can we increase the cell height to see
all the contents?

 

[Arvi Laanemets]

Hi

MS Excel2000 Help (Worksheet and workbook specifications):

Column width - 255 characters
Length of cell contents (text) - 32,767 characters. Only 1,024 display in a
cell; all 32,767 display in the formula bar.

Followingly: to display more as 255 characters use 'Wrap text' feature.

 

[Arvi Laanemets]

Hi

MS Excel2000 Help (Worksheet and workbook specifications):

Column width - 255 characters
Length of cell contents (text) - 32,767 characters. Only 1,024 display in a
cell; all 32,767 display in the formula bar.

Followingly: to display more as 255 characters use 'Wrap text' feature.

It looks like you have used it, I missed at first that you speaked about 300
words. With only 1024 characters maximally displayed in one cell, it's
practically impossible create a 300-word text passing this limitation - for
it most of words must be 2-character length.

Arvi Laanemets

 

[Ken Wright]

Previously posted by Harlan Grove:-

Does anyone know a way to get around the maximun text characters in a
cell that excel displays and prints

Manually add newline characters at regular intervals within the text by pressing
[Alt]+[Enter] with the cursor in those locations. If you use enough of these and
your zoom percentage and font's typesize are small enough and your row height
and column width large enough, you *can* display all 32767 chars that Excel can
hold in a cell.

One catch: there's no chance you'd be able to read any of them. 80 rows of 200
characters each is straining the limits of readability on most monitors, and
that's just 16,000 characters in total.