Excel table in word

  • Thread starter Thread starter carol
  • Start date Start date
C

carol

I have copied a table from excel into word and i need to know how to format
it so that the table fits onto one page. Currently, it is taking up a page
and a half but i want it to fit neatly onto one page. Any ideas?
 
I suggest that please reduce the column width of those which have very little
text, and increase the column width of the others with too much of data.
 
Try using "paste special" (go to Edit, then Paste Special) when pasting into
Word. It should help to keep the Excel formatting.
 
I've tried that but it doesn't seem to work. The problem is with the height
of the table not the width, (in autofit you can easily adjust the width, but
i can't find anything to adjest the height).
 
If you used paste special double click to edit the Excel sheet - when you
right click you can adjust the height. You you justed pasted the info, go to
you table properties and you can change the height there.
 

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

Similar Threads

Best Method of Importing Excel Tables 1
Formatting of excel worksheets in word 2
Compress a multi-page document onto fewer pages 1
Preserving Excel Page Layouts when Linking to word 1
How do I make an embeded Excel worksheet span more than one page? 1
Inserting Excel tables into Word 13
Word Copy & Paste 2
Can I shrink a page long table to 1/2 a page? 9

Back
Top