Can't see all text in Excel Cell

[Lynz]

Fairly large amounts of text pasted into cells. All cells have text wrapped,
aligned left and centred and have adjusted row height and column width but
still can't see all text in some cells. Does anyone know why this is
happening - particularly since it is not in all cells?

[Gord Dibben]

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, about every 100 characters..

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 or MS Word which is a word
processing application, unlike Excel which is not.

Gord Dibben Excel MVP

[bachfan23]

This is fantastic. Thank you.

On Jan 7, 6:48 pm, Gord Dibben <gorddibbATshawDOTca> wrote:
> 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, about every 100 characters..
>
> 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 or MS Word which is a word
> processing application, unlike Excel which is not.
>
> Gord Dibben Excel MVP
>

[shaybe...@gmail.com]

Thanks man!!
Very very helpfull!

בתאריך יום שלישי, 8 בינואר 2008 01:48:04 UTC+2, מאת Gord Dibben:

[halhen...@gmail.com]

On Monday, January 7, 2008 5:26:01 PM UTC-6, Lynz wrote:
> Fairly large amounts of text pasted into cells. All cells have text wrapped, aligned left and centred and have adjusted row height and column width but still can't see all text in some cells. Does anyone know why this is happening - particularly since it is not in all cells?

Just change the text format to General if you are not using formulas.

[pattyl...@gmail.com]

Now THAT was easy!

[remo...@gmail.com]

You might try adjusting the alignment of the line within the cell. Using Excel 2010, select:
Home
Alignment
Vertical
use the drop down box to adjust the line within the cell.