Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 8th 08, 12:26 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2008
Posts: 1
Default Can't see all text in Excel Cell

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?

  #2   Report Post  
Old January 8th 08, 12:48 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,908
Default Can't see all text in Excel Cell

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

On Mon, 7 Jan 2008 15:26:01 -0800, 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?


  #3   Report Post  
Old January 10th 08, 07:56 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2008
Posts: 1
Default Can't see all text in Excel Cell

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

On Mon, 7 Jan 2008 15:26:01 -0800, 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?


  #4   Report Post  
Old July 9th 13, 09:22 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2013
Posts: 1
Default Can't see all text in Excel Cell

Thanks man!!
Very very helpfull!

בתאריך יום שלישי, 8 בי*ואר 2008 01:48:04 UTC+2, מאת 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

On Mon, 7 Jan 2008 15:26:01 -0800, 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?


  #5   Report Post  
Old December 3rd 13, 07:52 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2013
Posts: 1
Default Can't see all text in Excel Cell

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.


  #6   Report Post  
Old August 13th 15, 09:30 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2015
Posts: 1
Default Can't see all text in Excel Cell

On Tuesday, December 3, 2013 at 1:52:21 PM UTC-5, wrote:
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.


Now THAT was easy!
  #7   Report Post  
Old November 5th 18, 10:12 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2018
Posts: 1
Default Can't see all text in Excel Cell

On Thursday, August 13, 2015 at 3:31:01 PM UTC-5, wrote:
On Tuesday, December 3, 2013 at 1:52:21 PM UTC-5, wrote:
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.


Now THAT was easy!


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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can not see text in Excel when cell format is set to wrap text Mark New Users to Excel 1 May 29th 07 02:07 PM
How do I convert a text array to a concatenated text cell? Excel. Vargasjc Excel Worksheet Functions 5 December 20th 06 07:35 PM
Text not continuing to wrap for large block of text in Excel cell Mandra Charts and Charting in Excel 1 May 15th 06 07:13 PM
How do I set text to top of cell next to wrap text in Excel? Carpenter Gary New Users to Excel 1 October 25th 05 06:26 PM
Need a macro to insert text in a cell that already has text.Excel go1angel Excel Discussion (Misc queries) 2 October 5th 05 10:32 PM


All times are GMT +1. The time now is 05:20 PM.

Powered by vBulletin® Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2004-2018 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017