Excel to Word tips anyone?

[Nightboy]

Does anyone have any good tips or tricks on copying tables from Excel to Word?

I generally just paste it as a picture as that takes least memory. It works OK, but I'm just wondering if there are any other good ideas that I'm not aware of.

 

[PaddyD]

First things first! Was my reply

http://www.mrexcel.com/board/viewtopic.php?topic=22908&forum=2

of any use?

Paddy

 

[Nightboy]

Yes thank you it did work. I was meaning to go back to that thread & let you know that it worked out.

 

[PaddyD]

OK - do you know about the 'camera' in excel?

1) right click on the tool bars & go to 'Customise'. select the commands tab
2) select the tools option & scroll down til you find the camera. add it to a tool bar...
3) select a range of cells, click the camera icon, then click somewhere else in the worksheet...
4) the camera can be used to dump the data into word as well (it turns up as a Word table).

or another often missed option:

1) select an area of cells
2) hold down the shift key, then go to the edit menu - you see a new option 'Copy picture'
3) Play around with the options to see the results in word...

Not necessarily 'better' than other methods, just a few more options...

Paddy

 

[Nightboy]

OK, I tried them. That is interesting. Camera will bring the data over linked, so if it is updated in Excel in will update in Word also. One thing is bothering me with one table - it is 16 columns in 11 point. I select the whole area, copy & paste into word as a picture, but it constantly leaves out the last column. When I go into "edit picture" the column isn't even there. So it's not because there is no room on the page. It is just not bringing it across. Any ideas on how to get around this?

 

[PaddyD]

what happens if you initially select 17 columns (i.e. include one extra, redundant column that you don't mind loosing if you can't find another way round the problem?)

Paddy

 

[Flenley]

Nightboy,

In Word Right Click on the import picture and select autofit, and then I think autofit to window (going from memory here).

This will resize the picture to fit.

Hope this helps

 

[Nightboy]

It still gives the same result. Whether I select 16, 17, 18 columns, etc it just pastes the first 15.

I am trying to paste it into an A4 portrait format page. Standard report layout. I actually just went & made a landscape format A4 doc & tried to copy & paste & it still leaves out the final column/s.

Perhaps it's something set up strange on my work computer. I might just go home & try it. Chances are it will come out perfectly there. Still I would like to know why it is doing this.

 

[Nightboy]

Flenley, the problem is that it isn't even bringing over the extra column. So resizing just makes it smaller still with 15 instead of 16 columns. Actually when I paste it into Word there is still plenty of room for a couple of extra columns on the page. I'm thinking now that it must be something in how Excel is set up on my work computer. I've never encountered this before.

 

[ThePencilQueen]

Is your print area in excel excluding this column?

(no idea if this would effect it but its worth checking)