Help!

Paste table from Excel to Word

 
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Tables RSS
Next:  Adding Up Columns in a Table  
Author Message
Amy
External


Since: Jan 11, 2005
Posts: 179



PostPosted: Thu Mar 01, 2007 4:53 pm    Post subject: Paste table from Excel to Word
Archived from groups: microsoft>public>word>tables (more info?)

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.
Back to top
challa prabhu
External


Since: Jan 07, 2007
Posts: 662



PostPosted: Fri Mar 02, 2007 3:48 am    Post subject: RE: Paste table from Excel to Word [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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.
Back to top
Shauna Kelly
External


Since: Sep 28, 2004
Posts: 712



PostPosted: Fri Mar 02, 2007 1:06 pm    Post subject: Re: Paste table from Excel to Word [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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

> 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.
Back to top
Amy
External


Since: Jan 11, 2005
Posts: 179



PostPosted: Fri Mar 02, 2007 1:06 pm    Post subject: Re: Paste table from Excel to Word [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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
>
> > 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.
>
>
>
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Tables All times are: Eastern Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum