Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to use text wrap property for tables.
I am trying to insert Excel data in word table using macro. I need the text
in tables to fit the cell size. How can I make it wrap. I tried ' tbl.Rows.WrapAroundText = True' , but it did not help. My Excel file has around 350 rows. How can I insert pagebreaks in word macro. |
#2
|
|||
|
|||
Text in Word tables wraps by default, and the row height increases
accordingly. Are you experiencing something different when you paste Excel data into Word? -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Nandini" wrote in message ... I am trying to insert Excel data in word table using macro. I need the text in tables to fit the cell size. How can I make it wrap. I tried ' tbl.Rows.WrapAroundText = True' , but it did not help. My Excel file has around 350 rows. How can I insert pagebreaks in word macro. |
#3
|
|||
|
|||
The text in the table boxes runs beyond the cell boundary into the next cell,
if the next cell is empty. I wanted it to wrap evenif the next cell is empty. "Suzanne S. Barnhill" wrote: Text in Word tables wraps by default, and the row height increases accordingly. Are you experiencing something different when you paste Excel data into Word? -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Nandini" wrote in message ... I am trying to insert Excel data in word table using macro. I need the text in tables to fit the cell size. How can I make it wrap. I tried ' tbl.Rows.WrapAroundText = True' , but it did not help. My Excel file has around 350 rows. How can I insert pagebreaks in word macro. |
#4
|
|||
|
|||
This does not happen in Word; text in a cell is always confined to that
cell. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Nandini" wrote in message ... The text in the table boxes runs beyond the cell boundary into the next cell, if the next cell is empty. I wanted it to wrap evenif the next cell is empty. "Suzanne S. Barnhill" wrote: Text in Word tables wraps by default, and the row height increases accordingly. Are you experiencing something different when you paste Excel data into Word? -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Nandini" wrote in message ... I am trying to insert Excel data in word table using macro. I need the text in tables to fit the cell size. How can I make it wrap. I tried ' tbl.Rows.WrapAroundText = True' , but it did not help. My Excel file has around 350 rows. How can I insert pagebreaks in word macro. |
#5
|
|||
|
|||
Let me try again. One more question.
How can set the width of the columns and set the text direction or orientation using the macro? - Thanks Nandini "Suzanne S. Barnhill" wrote: This does not happen in Word; text in a cell is always confined to that cell. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Nandini" wrote in message ... The text in the table boxes runs beyond the cell boundary into the next cell, if the next cell is empty. I wanted it to wrap evenif the next cell is empty. "Suzanne S. Barnhill" wrote: Text in Word tables wraps by default, and the row height increases accordingly. Are you experiencing something different when you paste Excel data into Word? -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Nandini" wrote in message ... I am trying to insert Excel data in word table using macro. I need the text in tables to fit the cell size. How can I make it wrap. I tried ' tbl.Rows.WrapAroundText = True' , but it did not help. My Excel file has around 350 rows. How can I insert pagebreaks in word macro. |
#6
|
|||
|
|||
If you are trying to do this programmatically, you would be better advised
to ask in one of the word.vba NGs. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Nandini" wrote in message ... Let me try again. One more question. How can set the width of the columns and set the text direction or orientation using the macro? - Thanks Nandini "Suzanne S. Barnhill" wrote: This does not happen in Word; text in a cell is always confined to that cell. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Nandini" wrote in message ... The text in the table boxes runs beyond the cell boundary into the next cell, if the next cell is empty. I wanted it to wrap evenif the next cell is empty. "Suzanne S. Barnhill" wrote: Text in Word tables wraps by default, and the row height increases accordingly. Are you experiencing something different when you paste Excel data into Word? -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Nandini" wrote in message ... I am trying to insert Excel data in word table using macro. I need the text in tables to fit the cell size. How can I make it wrap. I tried ' tbl.Rows.WrapAroundText = True' , but it did not help. My Excel file has around 350 rows. How can I insert pagebreaks in word macro. |
#7
|
|||
|
|||
Most likely, Word decided that the long line of text was intended as
some sort of heading for several columns and therefore merged the cells. That would create something like this: Cell 1, row 1 with long text | Cell 3, row 1 Cell 1, row 2 | Cell 2, row 2| Cell 3, row 2 Have you tried the Split command on the Table menu? -- Stefan Blom "Nandini" wrote in message ... The text in the table boxes runs beyond the cell boundary into the next cell, if the next cell is empty. I wanted it to wrap evenif the next cell is empty. "Suzanne S. Barnhill" wrote: Text in Word tables wraps by default, and the row height increases accordingly. Are you experiencing something different when you paste Excel data into Word? -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Nandini" wrote in message ... I am trying to insert Excel data in word table using macro. I need the text in tables to fit the cell size. How can I make it wrap. I tried ' tbl.Rows.WrapAroundText = True' , but it did not help. My Excel file has around 350 rows. How can I insert pagebreaks in word macro. |
#8
|
|||
|
|||
Clarification: The combination of "long line of text" and an empty
cell causes the problem. -- Stefan Blom "Stefan Blom" wrote in message ... Most likely, Word decided that the long line of text was intended as some sort of heading for several columns and therefore merged the cells. That would create something like this: Cell 1, row 1 with long text | Cell 3, row 1 Cell 1, row 2 | Cell 2, row 2| Cell 3, row 2 Have you tried the Split command on the Table menu? -- Stefan Blom "Nandini" wrote in message ... The text in the table boxes runs beyond the cell boundary into the next cell, if the next cell is empty. I wanted it to wrap evenif the next cell is empty. "Suzanne S. Barnhill" wrote: Text in Word tables wraps by default, and the row height increases accordingly. Are you experiencing something different when you paste Excel data into Word? -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Nandini" wrote in message ... I am trying to insert Excel data in word table using macro. I need the text in tables to fit the cell size. How can I make it wrap. I tried ' tbl.Rows.WrapAroundText = True' , but it did not help. My Excel file has around 350 rows. How can I insert pagebreaks in word macro. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Wrap text in a table row? | Microsoft Word Help | |||
how do you change the default text wrap | Microsoft Word Help | |||
How do you make text wrap in a paragraph? | Microsoft Word Help | |||
How do I force a Word custom property to be Text instead of Number | Microsoft Word Help | |||
Outline | Page Layout |