A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Tables
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Paste table from Excel to Word



 
 
Thread Tools Display Modes
  #1  
Old March 1st, 2007, 08:53 PM posted to microsoft.public.word.tables
Amy
external usenet poster
 
Posts: 412
Default Paste table from Excel to Word

I'm using Office 2003. I want to copy part of my Excel spreadsheet and paste
it into Word so that it appears as a table. However it goes off the edge of
the page in Word. I have been trying to get it to all fit on the page by
altering column widths, but I can't select the final columns to alter them
because they are off the page. Is there any better way to fix this than just
changing to landscape? I don't want to copy the table as a picture because I
want to be able to format it and possibly adjust some of the data in Word.
Thanks.
  #2  
Old March 1st, 2007, 10:06 PM posted to microsoft.public.word.tables
Shauna Kelly
external usenet poster
 
Posts: 572
Default Paste table from Excel to Word

Hi Amy

If you do want to be able to manipulate the columns off the page, do View
Normal and you can see and manipulate all the columns.

Alternatively, click in the table, and do Table Properties. On the Table
tab, click Options. Tick the box that says "Automatically resize to fit
contents" and click OK. Now, back on the Table tab, set the preferred width
to 100%.

You can now adjust the column widths to better suit your needs.

Hope this helps.

Shauna Kelly. Microsoft MVP.
http://www.shaunakelly.com/word


"Amy" wrote in message
news
I'm using Office 2003. I want to copy part of my Excel spreadsheet and
paste
it into Word so that it appears as a table. However it goes off the edge
of
the page in Word. I have been trying to get it to all fit on the page by
altering column widths, but I can't select the final columns to alter them
because they are off the page. Is there any better way to fix this than
just
changing to landscape? I don't want to copy the table as a picture because
I
want to be able to format it and possibly adjust some of the data in Word.
Thanks.



  #3  
Old March 1st, 2007, 10:19 PM posted to microsoft.public.word.tables
Amy
external usenet poster
 
Posts: 412
Default Paste table from Excel to Word

Thanks for your prompt response Shauna. I knew there must be an easy way!

It actually worked if I cleared the check box for "automatically resize to
fit contents", rather than ticking it.

Cheers,
Amy

"Shauna Kelly" wrote:

Hi Amy

If you do want to be able to manipulate the columns off the page, do View
Normal and you can see and manipulate all the columns.

Alternatively, click in the table, and do Table Properties. On the Table
tab, click Options. Tick the box that says "Automatically resize to fit
contents" and click OK. Now, back on the Table tab, set the preferred width
to 100%.

You can now adjust the column widths to better suit your needs.

Hope this helps.

Shauna Kelly. Microsoft MVP.
http://www.shaunakelly.com/word


"Amy" wrote in message
news
I'm using Office 2003. I want to copy part of my Excel spreadsheet and
paste
it into Word so that it appears as a table. However it goes off the edge
of
the page in Word. I have been trying to get it to all fit on the page by
altering column widths, but I can't select the final columns to alter them
because they are off the page. Is there any better way to fix this than
just
changing to landscape? I don't want to copy the table as a picture because
I
want to be able to format it and possibly adjust some of the data in Word.
Thanks.




  #4  
Old March 2nd, 2007, 07:48 AM posted to microsoft.public.word.tables
challa prabhu
external usenet poster
 
Posts: 750
Default Paste table from Excel to Word

Do the following:

1. Select two rows of 18 columns text - I enetered Mon on Column A to Column
18 Thu. in Microsoft Excel
2. Copied these two rows and Paste them in Microsoft Word.
3. Selected the table, and right-click and click Table Properties.
4. Click the Table Tab.
5. In the Measure in list, under Size, select Inches.
6. Enter any numeric value - for example enter 4 - In the Prefered Width box
and then select the Prefered Width check box.
7 Click OK.

Challa Prabhu


"Amy" wrote:

I'm using Office 2003. I want to copy part of my Excel spreadsheet and paste
it into Word so that it appears as a table. However it goes off the edge of
the page in Word. I have been trying to get it to all fit on the page by
altering column widths, but I can't select the final columns to alter them
because they are off the page. Is there any better way to fix this than just
changing to landscape? I don't want to copy the table as a picture because I
want to be able to format it and possibly adjust some of the data in Word.
Thanks.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:40 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.