Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Cell is too small?
I have a lot of text in my cell. After a while it stops wrapping the text, so
I can't print what is within the cell. I don't know why this is hapenning. how can I fix this? |
#2
|
|||
|
|||
Hi Tabby-
Cells were never intended to store large volumes of text. They have a limit of 409 points in height (roughly 34 lines of 10 pt. type, assuming 120% leading). There is also some technical glitch with content that falls within the 256-1024 character range. If you need to include that amount of text as a unit, you might want to consider using Cell Comments or drawing Text Boxes/AutoShapes to store, display & print that type of content more readily. Good Luck |:) "Tabbycat4" wrote: I have a lot of text in my cell. After a while it stops wrapping the text, so I can't print what is within the cell. I don't know why this is hapenning. how can I fix this? |
#3
|
|||
|
|||
If you add some alt-enters (to force newlines within the cell) every 80-100
characters, you'll be able to see a lot more characters. Tabbycat4 wrote: I have a lot of text in my cell. After a while it stops wrapping the text, so I can't print what is within the cell. I don't know why this is hapenning. how can I fix this? -- Dave Peterson |
#4
|
|||
|
|||
But that technical glitch is easily overcome by formatting the cell as general
(instead of Text). CyberTaz wrote: Hi Tabby- Cells were never intended to store large volumes of text. They have a limit of 409 points in height (roughly 34 lines of 10 pt. type, assuming 120% leading). There is also some technical glitch with content that falls within the 256-1024 character range. If you need to include that amount of text as a unit, you might want to consider using Cell Comments or drawing Text Boxes/AutoShapes to store, display & print that type of content more readily. Good Luck |:) "Tabbycat4" wrote: I have a lot of text in my cell. After a while it stops wrapping the text, so I can't print what is within the cell. I don't know why this is hapenning. how can I fix this? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cell color index comparison | New Users to Excel | |||
Cell Change Color - Need Help | New Users to Excel | |||
Pasting Word table cell with paragraph markers into single Excel c | Excel Discussion (Misc queries) | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |