Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can not see text in Excel when cell format is set to wrap text | New Users to Excel | |||
How do I convert a text array to a concatenated text cell? Excel. | Excel Worksheet Functions | |||
Text not continuing to wrap for large block of text in Excel cell | Charts and Charting in Excel | |||
How do I set text to top of cell next to wrap text in Excel? | New Users to Excel | |||
Need a macro to insert text in a cell that already has text.Excel | Excel Discussion (Misc queries) |