paste from excel to word

[TipGiver]

Hello,

I have created something in excel. I want to paste it in the word but i got some problems. If i do a simple paste, then it will be out of bounds, rows and cols will not have the right size... a mess!
So i do a special paste. This works, but is there any way to have the 'excel paste' splitted as the pages of the word change ??

One pretty bad idea would be to copy and paste it by pieces in order not to have much blanck space. This could work, but the new problem would be that I must then re-paste from excel, as i might add or delete some lines of the word.

Any ideas are welcome
Thnaks

 

[Auger282]

I would paste in two parts to keep it clean.. and control the end of the page with a page break... if you give yourself some room at the end of the page then you will have some leverage to add/remove/edit text.

Text
Table
Pagebreak
Table
Text

 

[TipGiver]

Hi !

This is what i called 'bad idea'.
I want the data to be continuous. I may use page breaks somewhere else.. The problem is how a matrix from excel (size > 1 page of word) could be splitted. The special paste does one part, and that is to keep the pasted data exactly like excel. The other one would be to have it split.

The page break is helpful somewhere else, but here, I may add lines and if the matrix exceeds the page, i'll end up with :
1. Data + enough space
2. One blanck page
3. A page with the matrix

Thanks so far

 

[SkipVought]

Hi,

We're sitting here in the dusk, without the benefit of what your ultimate objective is.

YOU know what you want. WE have only pieces based on the fragments of clues that you have sparingly provided.

How about letting us in on what's in your head? Many times a question is asked for some specific method, when the REAL QUESTION could be answered using an entirely different approch that makes more sense.

Please be CLEAR, COMCISE and COMPLETE.

Skip,

_[red][/red]

 

[TipGiver]

ok then


-> I have created something in Excel

>> I select all of it, and paste it in the Word.
>> I want the pasted data to be exactly as they are in Excel (it fails when i do a simple paste, succeeds when i do 'paste special')

?> The problem is that what i paste; it cannot be split into one or more pages in MS Word.

 

[SkipVought]

What kind of Paste Special?

Did you try a Microsoft Office Excel Object?

Skip,

_[red][/red]

 

[TipGiver]

Yes.
..but nothing

 

[SkipVought]

But Nothing?

When I do it, I get multiple pages in Word.

And you get nothing???

Skip,

_[red][/red]

 

[TipGiver]

The data start from the beginning of the page and end at the bottom of the page. I can't see the bottom side of the excel object.. and this means that there are data that are not displayed.

 

[SkipVought]

ALL on the same page in Word?

How many rows & columns did you copy in Excel?

Skip,

_[red][/red]

 

[Gavona]

I am looking foward to a solution to this one as the team I work with have problems with this. Funny thing is, at home it doesn't seem so bad. Could it be differences beween Office 2003 and Office 2000? Or between the default table properties?
At home (office 2003) I paste, or paste special as HTML and the excel data goes into a table. That table DOES wrap to the next page and as far as I can see the formatting and column widths are similar, except that numbers become left aligned, where a cell wraps varies (and therefore the row height).
There are, I note options in Word (Table, Table Properties, Row, "Allow Break Across Pages").

Another issue I have with pasting between Excel and word is that in Excel I can set in page set up to shrink to fit. With margins etc in Word my tables are often a bit too wide or long to fit on a page. I would love a technique to "shrink table to fit" OR a "shrink table by 1%" button.


Gavin

 

[TipGiver]

How many rows & columns did you copy in Excel?
> 5 Columns and 100 rows
The problem is with the many rows.

 

[SkipVought]

Again...

ALL on the same page in Word?

Skip,

_[red][/red]

 

[TipGiver]

Yes. But some rows are out of the page borders... so if i print, only 40 or so rows will be printed. Below, the outer is the word's page, and the inside the data. Those rows that do NOT fit in the page, do NOT go to a new page. And so they are not printed.

|--------------|
| |-----| |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
|--------------|
| |
| |
| |
.
.
.

 

[SkipVought]

Hmmmm. When I paste special an Excel Object, I get mulitple pages. I have 2003. Are you running another version?

Skip,

_[red][/red]

 

[SkipVought]

Have you played with the Options - Compatability Tab properties that relate to tables?

Skip,

_[red][/red]

 

[TipGiver]

Hi. I also have office 2003, with all service packs.
I will run some more tests..

Thanks so far

 

[Gavona]

How many rows & columns did you copy in Excel?
> 5 Columns and 100 rows
The problem is with the many rows.

Well, I have now tested with 282 rows and as per my first post (and Skip's) in Office 2003 that produces multiple pages.

Which PasteSpecial options you are using?
(For example if I choose "Microsoft Office Excel Object then for me that does NOT produce multiple pages. If I choose "Formatted Text" then the font size is not replicated (bizare?) but I do get a table that spills over onto as many pages as needed. If I choose "HTML Format" then font size is replicated and the table spills onto multiple pages (but I get the issues referred to in my first post.)

Which versions of Word / Excel are you using?

Personally to get the above results I have not played with the option Skip refers to - they are all unticked)


Gavin