Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Wrap and merge text will not show all lines
I am using a required formate for a report done in Excel. The odd lines use
5 blocks and the even lines use these blocks merged into one to fill with text. When the data is 9 or more lines long it quits wrapping so cannot be read. My report is due and I cannot figure out how to fix this. Any ideas or is this a program problem? |
#2
|
|||
|
|||
Text does stop wrapping in a cell after about 1000 characters. You might
consider putting the text in a text box (from the Drawing toolbar). -- Jim "jar57" wrote in message ... |I am using a required formate for a report done in Excel. The odd lines use | 5 blocks and the even lines use these blocks merged into one to fill with | text. When the data is 9 or more lines long it quits wrapping so cannot be | read. | | My report is due and I cannot figure out how to fix this. Any ideas or is | this a program problem? |
#3
|
|||
|
|||
Try adding some alt-enters (to force new lines within the cell) every 80-100
characters. You'll see more characters. (You may have to resize the rowheight, though.) jar57 wrote: I am using a required formate for a report done in Excel. The odd lines use 5 blocks and the even lines use these blocks merged into one to fill with text. When the data is 9 or more lines long it quits wrapping so cannot be read. My report is due and I cannot figure out how to fix this. Any ideas or is this a program problem? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
two lines of text in a single row? | Excel Discussion (Misc queries) | |||
display multiple lines of text within a merged cell automatically | Excel Worksheet Functions | |||
Row height is not adjusting after activating Merge Cells & Wrap Te | Excel Worksheet Functions | |||
can wrap text and merge be used together? | Excel Discussion (Misc queries) | |||
Concatenation formula loses text wrap formatting | Excel Discussion (Misc queries) |