Home |
Search |
Today's Posts |
#1
|
|||
|
|||
large text amount in cell will not display in the cell
With a large amount of text in a cell, word wrap enabled, row autofit
enabled, column width 81.71, only 12 lines of text will display. The total text will display in the formula bar. I can manually increase the row height, but the additional text will not display. How do I increase the amount of text displayed in an individual cell? Thanks. -- dbelch01 |
#2
|
|||
|
|||
Add some manual (forced) line breaks - <Alt <Enter - at some appropriate
places. This will increase the amount of displayed text. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "dbelch01" wrote in message ... With a large amount of text in a cell, word wrap enabled, row autofit enabled, column width 81.71, only 12 lines of text will display. The total text will display in the formula bar. I can manually increase the row height, but the additional text will not display. How do I increase the amount of text displayed in an individual cell? Thanks. -- dbelch01 |
#3
|
|||
|
|||
XL's specifications are that cells can contain 32767 characters, of
which 1024 will be displayed or printed. You can enter a manual linefeed (Alt-Enter) at least every 1024 characters to bypass the display limit. In article , "dbelch01" wrote: With a large amount of text in a cell, word wrap enabled, row autofit enabled, column width 81.71, only 12 lines of text will display. The total text will display in the formula bar. I can manually increase the row height, but the additional text will not display. How do I increase the amount of text displayed in an individual cell? |
#4
|
|||
|
|||
Add alt-enters (to force a new line within the cell) every 80-100 characters.
dbelch01 wrote: With a large amount of text in a cell, word wrap enabled, row autofit enabled, column width 81.71, only 12 lines of text will display. The total text will display in the formula bar. I can manually increase the row height, but the additional text will not display. How do I increase the amount of text displayed in an individual cell? Thanks. -- dbelch01 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
display multiple lines of text within a merged cell automatically | Excel Worksheet Functions | |||
Is there a limit on amount of text that can go into a cell? | Excel Discussion (Misc queries) | |||
Why does Custom Format not control Cell Display? | Excel Discussion (Misc queries) | |||
Why doesn't text wrap in a cell in Excel? | Excel Discussion (Misc queries) | |||
Copy text from same cell on every sheet to title sheet? | Excel Discussion (Misc queries) |