Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Cell Text Cutting Off
I have a large amount of text that I am inputting into a merged cell. When I
am editing the text, all the content displays. When I click outside the cell, only a portion of the text displays. How can I get the entire text to display in the cell? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Cell Text Cutting Off
You can enter 32,767 characters in a cell.
Unfortunately only about 1024 will show or print. If you add an Alt + Enter every 100 characters you can increase this limit. BTW...............merging multiple cells does not increase this limit. You still have one cell. Gord Dibben MS Excel MVP On Thu, 2 Aug 2007 16:36:00 -0700, Jones wrote: I have a large amount of text that I am inputting into a merged cell. When I am editing the text, all the content displays. When I click outside the cell, only a portion of the text displays. How can I get the entire text to display in the cell? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Cell Text Cutting Off
Thank you, Gord - when I counted the characters, it totaled 1683 with spaces
and 1431 without spaces. From the information you provided, my text should display. I played with the table height, formatting the cells, I am missing something. I will probably slap my forehead when I hear or figure it out. Do you have any suggestions? "Gord Dibben" wrote: You can enter 32,767 characters in a cell. Unfortunately only about 1024 will show or print. If you add an Alt + Enter every 100 characters you can increase this limit. BTW...............merging multiple cells does not increase this limit. You still have one cell. Gord Dibben MS Excel MVP On Thu, 2 Aug 2007 16:36:00 -0700, Jones wrote: I have a large amount of text that I am inputting into a merged cell. When I am editing the text, all the content displays. When I click outside the cell, only a portion of the text displays. How can I get the entire text to display in the cell? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Cell Text Cutting Off
About 1024 includes spaces. And both 1683 and 1431 are larger than 1024.
You'll want to add those alt-enters every 80-100 characters to see more than 1024 (about) characters. Jones wrote: Thank you, Gord - when I counted the characters, it totaled 1683 with spaces and 1431 without spaces. From the information you provided, my text should display. I played with the table height, formatting the cells, I am missing something. I will probably slap my forehead when I hear or figure it out. Do you have any suggestions? "Gord Dibben" wrote: You can enter 32,767 characters in a cell. Unfortunately only about 1024 will show or print. If you add an Alt + Enter every 100 characters you can increase this limit. BTW...............merging multiple cells does not increase this limit. You still have one cell. Gord Dibben MS Excel MVP On Thu, 2 Aug 2007 16:36:00 -0700, Jones wrote: I have a large amount of text that I am inputting into a merged cell. When I am editing the text, all the content displays. When I click outside the cell, only a portion of the text displays. How can I get the entire text to display in the cell? -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Cell Text Cutting Off
Thank you Dave and Gordon - egg on my face. Although I read the message, I
still forgot about the display factor. I will put in the alt-enters. Thanks for being understanding and still willing to help out someone who could not 'see the forest through the trees'. Happy Friday! "Dave Peterson" wrote: About 1024 includes spaces. And both 1683 and 1431 are larger than 1024. You'll want to add those alt-enters every 80-100 characters to see more than 1024 (about) characters. Jones wrote: Thank you, Gord - when I counted the characters, it totaled 1683 with spaces and 1431 without spaces. From the information you provided, my text should display. I played with the table height, formatting the cells, I am missing something. I will probably slap my forehead when I hear or figure it out. Do you have any suggestions? "Gord Dibben" wrote: You can enter 32,767 characters in a cell. Unfortunately only about 1024 will show or print. If you add an Alt + Enter every 100 characters you can increase this limit. BTW...............merging multiple cells does not increase this limit. You still have one cell. Gord Dibben MS Excel MVP On Thu, 2 Aug 2007 16:36:00 -0700, Jones wrote: I have a large amount of text that I am inputting into a merged cell. When I am editing the text, all the content displays. When I click outside the cell, only a portion of the text displays. How can I get the entire text to display in the cell? -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Cell Text Cutting Off
Hi,
If you enter the text in a single cell, the text wrap checkbox, in the Text Control section of the Alignment tab automatically gets selected and the text wraps completely within the cell. But if you merge one or more cell using the Text Wrap under the Text Control section in the Alignment tab, you must manually adjust the Width and length of the cell using the mouse. Challa Prabhu "Jones" wrote: I have a large amount of text that I am inputting into a merged cell. When I am editing the text, all the content displays. When I click outside the cell, only a portion of the text displays. How can I get the entire text to display in the cell? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cutting characters from a cell | Excel Worksheet Functions | |||
How to maintain merged cell format when cutting the content away | Excel Worksheet Functions | |||
Wrap text without cutting top off text | Excel Discussion (Misc queries) | |||
Contents of cell not wrapping cutting off text | Setting up and Configuration of Excel | |||
cutting text | Excel Discussion (Misc queries) |