table from excel to word

A

annasund

I have copied an excel table to word, but how do I do if I want the table to
"lay down" on a whole A4 page in Word? Is there a function to flip a table in
word that´s been taken from excel?
 
R

Rae Drysdale

Are you wishing to transpose your rows and columns? You can do this in Excel
before you paste into Word. Copy the cells in Excel, click in another cell,
select Paste Special and then place a checkmark in the transpose box. You can
then copy this table into Word.
 
N

Ned23

If this is a "static" table that will remain unchanged and independent of the
excel file then one easy way to transfer the table is as follows:

1. Format the table in Excel exactly as you want it to appear in Word.
2. Select the table in Excel
3. Click on the PASTE clip board icon in the HOME Tab
4. At the bottom of the PASTE pop-up that appears select "as Picture"
5. In the "Copy as Picture" dialog box /window that appears select "As
Shown when Printed"
6. Click "OK"
7. Paste the copied image into Word

This creates an enhanced metafile with embeded fonts and vector graphics
that can easily be resized and moved in Word without distorting the fonts.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top