Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
text wrap
How do I text wrap past maximum characters (per cell) in an Excel worksheet?
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
text wrap
-Right click the cell
-Format cells -Alignment -Check the "Wrap Text" box. HTH, Ken Puls, CMA - Microsoft MVP (Excel) www.excelguru.ca kaye2681 wrote: How do I text wrap past maximum characters (per cell) in an Excel worksheet? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
text wrap
If you are at maximum characters how would you expect to get more?
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 Fri, 27 Oct 2006 09:25:02 -0700, kaye2681 wrote: How do I text wrap past maximum characters (per cell) in an Excel worksheet? Gord Dibben MS Excel MVP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text not continuing to wrap for large block of text in Excel cell | Charts and Charting in Excel | |||
I am using wrap text in excel, so why isn't all my text wrapping? | Excel Discussion (Misc queries) | |||
Just one cell in an Excel column won't text wrap. | New Users to Excel | |||
How do I set text to top of cell next to wrap text in Excel? | New Users to Excel | |||
Concatenation formula loses text wrap formatting | Excel Discussion (Misc queries) |