Amount of Data in a Cell Displayed On Screen/Print

[James H]

I hope someone can give me some advice around how data is shown on screen.

I have spreadsheets with fairly large numbers of characters in cells (circa
2,000 per cell) and when viewing the spreadsheet on screen, even by varying
the
Row Height/Column Width not all of the characters can be seen on screen.
When the Row Heights/Column Widths are extended to the point where the
characters should all fit on screen, there is then blank space at the
beginning of the cell but the characters at the end are still missing. This
also happens when printing/print previewing the worksheets.

Has anyone come across this phenomenon? Do you have solution that will
enable
all characters in the cell to be seen on screen/print or am I just outside
Excel's parameters? I am aware that by using the Insert Comment feature I
can at least see all the data on screen (by resizing the comment box) but
this will not allow any of the Excel functionality to be used.

Any help and advice you can give would be very much appreciated.

Thanks,

James H.

 

[JulieD]

Hi James

from Help - "Excel Specifications and Limits"

 

[James H]

Hi James

from Help - "Excel Specifications and Limits"

Julie,

Thanks very much for your assistance - I wish I spent more time searching
the help rather that playing now

Cheers,

James.

 

[Gord Dibben]

James

As Julie has pointed out.......

Excel Help on "limits" or "specifications" reveals that Excel will allow
32,767 characters to be entered in a cell.

However, it goes on to state that "only 1024 characters will be visible or can
be printed"

To work around this limitation, stick a few ALT + ENTERs in at appropriate
spots.

The ALT + ENTER forces a line-feed and expands the 1024 limit.

How far is not really known. Just experiment.

.........From Dave Peterson..........

I put this formula in A1:
="xxx"& REPT(REPT("asdf ",25)&CHAR(10),58)&"yyy"

And adjusted the columnwidth, rowheight and font size and I got about 7300
characters to print ok.

.........End Dave P.................

Failing that, use a Text Box to store the text.


Gord Dibben Excel MVP