Home |
Search |
Today's Posts |
#1
|
|||
|
|||
I have text in an Excel Cell that isn't showing all of it?
I have Text in Excel that will not display..meaning its a lot of text and
only part is showing. I have selected wrap text and auto fit for column and row height. I can expland the cell but the text wont show (all of it)...it shows up to a certain point. Any Ideas?? |
#2
|
|||
|
|||
This is from a reply written by Cyber Taz. The question is similar to
yours. 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. |
#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. Ivey wrote: I have Text in Excel that will not display..meaning its a lot of text and only part is showing. I have selected wrap text and auto fit for column and row height. I can expland the cell but the text wont show (all of it)...it shows up to a certain point. Any Ideas?? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Does Excel 2003 have a shortcut command to wrap text in a cell? | Excel Discussion (Misc queries) | |||
A 2 line text showing up in the Cell in Excel prints in 1 line | Excel Discussion (Misc queries) | |||
Auto-Enter Text in Excel Fields | Excel Discussion (Misc queries) | |||
in excel can one repeat the text from a the last used column cell. | Excel Discussion (Misc queries) | |||
Text in cell not showing in full | Excel Discussion (Misc queries) |