Home |
Search |
Today's Posts |
#1
|
|||
|
|||
text wrapping in Excel 2003
I have formatted a cell so the text wrapping is active, however, only the
first 8 or 9 lines will wrap--then the text travels outside the cell and i am having to manually wrap it, which is very time consuming. Do i possibly have something set wrong somewhere? |
#2
|
|||
|
|||
Hi
could you mail me an example sheet -- Regards Frank Kabel Frankfurt, Germany "Tia" schrieb im Newsbeitrag ... I have formatted a cell so the text wrapping is active, however, only the first 8 or 9 lines will wrap--then the text travels outside the cell and i am having to manually wrap it, which is very time consuming. Do i possibly have something set wrong somewhere? |
#3
|
|||
|
|||
Hello Frank! Thank you so much for offering to take a look at this problem
for us!! It doesn't seem like i can add an attachement to this posting. Would you be able to email me directly so i can forward the Excel doument to you? (donotspam) Thank you!! "Frank Kabel" wrote: Hi could you mail me an example sheet -- Regards Frank Kabel Frankfurt, Germany "Tia" schrieb im Newsbeitrag ... I have formatted a cell so the text wrapping is active, however, only the first 8 or 9 lines will wrap--then the text travels outside the cell and i am having to manually wrap it, which is very time consuming. Do i possibly have something set wrong somewhere? |
#4
|
|||
|
|||
Hi
just send the file to frank[dot]kabel[at]freenet[dot]de -- Regards Frank Kabel Frankfurt, Germany Tia wrote: Hello Frank! Thank you so much for offering to take a look at this problem for us!! It doesn't seem like i can add an attachement to this posting. Would you be able to email me directly so i can forward the Excel doument to you? (donotspam) Thank you!! "Frank Kabel" wrote: Hi could you mail me an example sheet -- Regards Frank Kabel Frankfurt, Germany "Tia" schrieb im Newsbeitrag ... I have formatted a cell so the text wrapping is active, however, only the first 8 or 9 lines will wrap--then the text travels outside the cell and i am having to manually wrap it, which is very time consuming. Do i possibly have something set wrong somewhere? |
#5
|
|||
|
|||
Hi
and before sending it try inserting some manual linebreaks with AT+ENTER every other line bel Frankfurt, Germany Tia wrote: Hello Frank! Thank you so much for offering to take a look at this problem for us!! It doesn't seem like i can add an attachement to this posting. Would you be able to email me directly so i can forward the Excel doument to you? (donotspam) Thank you!! "Frank Kabel" wrote: Hi could you mail me an example sheet -- Regards Frank Kabel Frankfurt, Germany "Tia" schrieb im Newsbeitrag ... I have formatted a cell so the text wrapping is active, however, only the first 8 or 9 lines will wrap--then the text travels outside the cell and i am having to manually wrap it, which is very time consuming. Do i possibly have something set wrong somewhere? |
#6
|
|||
|
|||
Hi,
I am having this same problem? Was a solution found? Thanks! "Frank Kabel" wrote: Hi and before sending it try inserting some manual linebreaks with AT+ENTER every other line bel Frankfurt, Germany Tia wrote: Hello Frank! Thank you so much for offering to take a look at this problem for us!! It doesn't seem like i can add an attachement to this posting. Would you be able to email me directly so i can forward the Excel doument to you? (donotspam) Thank you!! "Frank Kabel" wrote: Hi could you mail me an example sheet -- Regards Frank Kabel Frankfurt, Germany "Tia" schrieb im Newsbeitrag ... I have formatted a cell so the text wrapping is active, however, only the first 8 or 9 lines will wrap--then the text travels outside the cell and i am having to manually wrap it, which is very time consuming. Do i possibly have something set wrong somewhere? |
#7
|
|||
|
|||
Frank's response to add some alt-enters (every 80-100 characters) is a common
fix to this. Didn't it work for you? Kristen wrote: Hi, I am having this same problem? Was a solution found? Thanks! "Frank Kabel" wrote: Hi and before sending it try inserting some manual linebreaks with AT+ENTER every other line bel Frankfurt, Germany Tia wrote: Hello Frank! Thank you so much for offering to take a look at this problem for us!! It doesn't seem like i can add an attachement to this posting. Would you be able to email me directly so i can forward the Excel doument to you? (donotspam) Thank you!! "Frank Kabel" wrote: Hi could you mail me an example sheet -- Regards Frank Kabel Frankfurt, Germany "Tia" schrieb im Newsbeitrag ... I have formatted a cell so the text wrapping is active, however, only the first 8 or 9 lines will wrap--then the text travels outside the cell and i am having to manually wrap it, which is very time consuming. Do i possibly have something set wrong somewhere? -- Dave Peterson |
#8
|
|||
|
|||
Hi Dave,
Yes, this works. However, there are so many occurences in the document that it will be very time consuming to use Alt-enter for each instance. I was hoping there was an easier fix. Thanks. Have a good day. Kristen "Dave Peterson" wrote: Frank's response to add some alt-enters (every 80-100 characters) is a common fix to this. Didn't it work for you? Kristen wrote: Hi, I am having this same problem? Was a solution found? Thanks! "Frank Kabel" wrote: Hi and before sending it try inserting some manual linebreaks with AT+ENTER every other line bel Frankfurt, Germany Tia wrote: Hello Frank! Thank you so much for offering to take a look at this problem for us!! It doesn't seem like i can add an attachement to this posting. Would you be able to email me directly so i can forward the Excel doument to you? (donotspam) Thank you!! "Frank Kabel" wrote: Hi could you mail me an example sheet -- Regards Frank Kabel Frankfurt, Germany "Tia" schrieb im Newsbeitrag ... I have formatted a cell so the text wrapping is active, however, only the first 8 or 9 lines will wrap--then the text travels outside the cell and i am having to manually wrap it, which is very time consuming. Do i possibly have something set wrong somewhere? -- Dave Peterson |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
text wrapping in Excel 2003
Same problem!! Did anyone find a way to fix it without resorting to
alt-enter?? Sounds like a common problem!!! "Kristen" wrote: Hi Dave, Yes, this works. However, there are so many occurences in the document that it will be very time consuming to use Alt-enter for each instance. I was hoping there was an easier fix. Thanks. Have a good day. Kristen "Dave Peterson" wrote: Frank's response to add some alt-enters (every 80-100 characters) is a common fix to this. Didn't it work for you? Kristen wrote: Hi, I am having this same problem? Was a solution found? Thanks! "Frank Kabel" wrote: Hi and before sending it try inserting some manual linebreaks with AT+ENTER every other line bel Frankfurt, Germany Tia wrote: Hello Frank! Thank you so much for offering to take a look at this problem for us!! It doesn't seem like i can add an attachement to this posting. Would you be able to email me directly so i can forward the Excel doument to you? (donotspam) Thank you!! "Frank Kabel" wrote: Hi could you mail me an example sheet -- Regards Frank Kabel Frankfurt, Germany "Tia" schrieb im Newsbeitrag ... I have formatted a cell so the text wrapping is active, however, only the first 8 or 9 lines will wrap--then the text travels outside the cell and i am having to manually wrap it, which is very time consuming. Do i possibly have something set wrong somewhere? -- Dave Peterson |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
text wrapping in Excel 2003
Anne
This is not a problem as far as MS is concerned. The 1024 character limit has been around for a few versions. Excel is not considered to be a word processing program so not much effort has been expended to add WP features and functionality. The Alt + Enter trick is what works for now. Gord Dibben MS Excel MVP On Fri, 4 Aug 2006 07:52:01 -0700, Anne wrote: Same problem!! Did anyone find a way to fix it without resorting to alt-enter?? Sounds like a common problem!!! "Kristen" wrote: Hi Dave, Yes, this works. However, there are so many occurences in the document that it will be very time consuming to use Alt-enter for each instance. I was hoping there was an easier fix. Thanks. Have a good day. Kristen "Dave Peterson" wrote: Frank's response to add some alt-enters (every 80-100 characters) is a common fix to this. Didn't it work for you? Kristen wrote: Hi, I am having this same problem? Was a solution found? Thanks! "Frank Kabel" wrote: Hi and before sending it try inserting some manual linebreaks with AT+ENTER every other line bel Frankfurt, Germany Tia wrote: Hello Frank! Thank you so much for offering to take a look at this problem for us!! It doesn't seem like i can add an attachement to this posting. Would you be able to email me directly so i can forward the Excel doument to you? (donotspam) Thank you!! "Frank Kabel" wrote: Hi could you mail me an example sheet -- Regards Frank Kabel Frankfurt, Germany "Tia" schrieb im Newsbeitrag ... I have formatted a cell so the text wrapping is active, however, only the first 8 or 9 lines will wrap--then the text travels outside the cell and i am having to manually wrap it, which is very time consuming. Do i possibly have something set wrong somewhere? -- Dave Peterson |
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
text wrapping in Excel 2003
Alt&Enter is fine unless the appearance of the text needs to be OK both on
screen and when printed (forced breaks using Alt&Enter can appear in the 'wrong' place when the sheet is peinted). If this is the case, copy your text into a text box, and drag the borders of the text box to exactly the same width and height as your merged cells. You can use format text box to remove the border if required. -- Bertie C "Gord Dibben" wrote: Anne This is not a problem as far as MS is concerned. The 1024 character limit has been around for a few versions. Excel is not considered to be a word processing program so not much effort has been expended to add WP features and functionality. The Alt + Enter trick is what works for now. Gord Dibben MS Excel MVP On Fri, 4 Aug 2006 07:52:01 -0700, Anne wrote: Same problem!! Did anyone find a way to fix it without resorting to alt-enter?? Sounds like a common problem!!! "Kristen" wrote: Hi Dave, Yes, this works. However, there are so many occurences in the document that it will be very time consuming to use Alt-enter for each instance. I was hoping there was an easier fix. Thanks. Have a good day. Kristen "Dave Peterson" wrote: Frank's response to add some alt-enters (every 80-100 characters) is a common fix to this. Didn't it work for you? Kristen wrote: Hi, I am having this same problem? Was a solution found? Thanks! "Frank Kabel" wrote: Hi and before sending it try inserting some manual linebreaks with AT+ENTER every other line bel Frankfurt, Germany Tia wrote: Hello Frank! Thank you so much for offering to take a look at this problem for us!! It doesn't seem like i can add an attachement to this posting. Would you be able to email me directly so i can forward the Excel doument to you? (donotspam) Thank you!! "Frank Kabel" wrote: Hi could you mail me an example sheet -- Regards Frank Kabel Frankfurt, Germany "Tia" schrieb im Newsbeitrag ... I have formatted a cell so the text wrapping is active, however, only the first 8 or 9 lines will wrap--then the text travels outside the cell and i am having to manually wrap it, which is very time consuming. Do i possibly have something set wrong somewhere? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I Excel to re-size when wrapping text in merged cells | Excel Discussion (Misc queries) | |||
Creating GIFs in Excel 2003 for use in Dreamweaver | Charts and Charting in Excel | |||
Stock Quotes in Excel 2003 | Excel Discussion (Misc queries) | |||
Excel 97 to Excel 2003 | Excel Discussion (Misc queries) | |||
Excel 2003 Database Driver Visual FoxPro 7 on Server 2003. | Excel Discussion (Misc queries) |