Copy and paste problem Excel 2003 to Word 2003
 

I'm trying to copy and paste a block of data 28 rows 17 columns from
Excel to Word.

Two problems, some of the excel data is lines of an address, and the
cells which contain an address like "41 High Street" seem to merge
over two or three cells when pasted to word. I have smart tags
switched off. The new word table has different number of cells in
different rows. The only way I can find to solve this is to wrap the
text in the excel spreadsheet before I copy it. But then the
spreadsheet is hard to read.

Secondly when I past into word, the table is partly off the right hand
side of the page. Is there an easy solution?.

Can anyone help me please?

Thanks.

Copy and paste problem Excel 2003 to Word 2003
 

17 columns is rather a lot for a Word table. It's around a page and a half
in Excel, using the standard column widths and margins.

When your text doesn't fit into a single cell in Excel, it spills over cells
to the right, seeming to fill the cells until it hits a non-empty cell. Word
doesn't let you not show all the contents of a cell, and the export routine
apparently assumes you want the same appearance as in Excel. That's why it
merges some cells. Back over in Word you could manually split the cells if
necessary.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


wrote in message
oups.com...
I'm trying to copy and paste a block of data 28 rows 17 columns from
Excel to Word.

Two problems, some of the excel data is lines of an address, and the
cells which contain an address like "41 High Street" seem to merge
over two or three cells when pasted to word. I have smart tags
switched off. The new word table has different number of cells in
different rows. The only way I can find to solve this is to wrap the
text in the excel spreadsheet before I copy it. But then the
spreadsheet is hard to read.

Secondly when I past into word, the table is partly off the right hand
side of the page. Is there an easy solution?.

Can anyone help me please?

Thanks.

Copy and paste problem Excel 2003 to Word 2003
 

Hi,

17 cloumns is managable in Word.

You could probabily this way:

1. Open a New word document.
2. On the File menu, click Page Setup.
3. Click the Margin tab, change the Top, Bottom, Left and Right to .5 inches.
4. Under Orientation, click Landccape
5. Click Ok to save and return to the active worksheet.
6. In the Standard toolbar, click the Insert tabl icon and select a single
dimenstion array of 1x17 matrix. 1x15 is manageable, but any more requires
tweeking.
7. Verify whether the all the cell are in a equi-distant. If you are happy
with the table then copy the table form Microsoft Excel and paste them in the
new document.

Note: You must adjust the cell dimenstion and Font size, to suite balance
between the Excel worksheet and Word.

Challa Prabhu

" wrote:

I'm trying to copy and paste a block of data 28 rows 17 columns from
Excel to Word.

Two problems, some of the excel data is lines of an address, and the
cells which contain an address like "41 High Street" seem to merge
over two or three cells when pasted to word. I have smart tags
switched off. The new word table has different number of cells in
different rows. The only way I can find to solve this is to wrap the
text in the excel spreadsheet before I copy it. But then the
spreadsheet is hard to read.

Secondly when I past into word, the table is partly off the right hand
side of the page. Is there an easy solution?.

Can anyone help me please?

Thanks.