pasting excel worksheet in word

[ryan]

I am trying to paste an Excel worksheet into a Word
document - I would like to format it so the worksheet
fits onto just one Word page, currently it takes up about
three pages and I can't figure out how to reduce it. Any
help would be great, thanks.

 

[Edward]

Hi, Ryan,

Word and Excel are incompatible so pasting will not work.

To print an Excel sheet take a look at it first - open the worksheet and
select "View/Page Break View". From there you can adjust the page layouts to
suit your sheet. You can view the whole thing by clicking "File/Print
Preview" (or the little magnifying glass)

Setting the print aea to Landscape or Portrait are also options.

Good luck,

Ed

 

[Beth Melton]

Hi Edward,

Since when are Word and Excel incompatible?????

--
Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/

 

[Mike Williams [MVP]]

I am trying to paste an Excel worksheet into a Word
document - I would like to format it so the worksheet
fits onto just one Word page, currently it takes up about
three pages and I can't figure out how to reduce it. Any
help would be great, thanks.

There are a few ways to skin this cat
* paste the Excel range into Word as a table. You may have to do some
column, row and font size juggling when this is done. This is probably waht
you've done but I don't know the contents of your worksheet/table
* insert an Excel worksheet object into Word. Insert > Object > From file
(pick your spreadsheet).

 

[Beth Melton]

Hi Ryan,

You are limited to a single page for an embedded object, such as an
Excel worksheet. This is accomplished by using Edit/Paste Special/As
Microsoft Excel Worksheet Object. Also note scaling the worksheet
using the View/Page Break Preview method Edward described will not
carry over to Word. Instead, you would need to reduce font sizes,
column widths, etc.

If the worksheet must continue to more than one page then you have
several choices. Here are a couple:

You can paste the Excel worksheet into Word (which is the default for
the Paste command) and allow Word to convert it to a Word table.
However in doing so you will lose all Excel capabilities such as
formulas/functions and you would utilize the Word table format
features.

You can use the Edit/Paste Special/as Rich Text Format and use the
Paste Link option. This will allow you to maintain formulas/functions
in the Excel worksheet and you can update the link in Word if the
worksheet content should change. This will also enable to you utilize
some of the Excel formatting.

--
Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/

 

[Edward]

What I mean, Beth, is - by pasting you finish with tables that are
unrepresentative of the Excel document. Sure, you can paste a simple table -
but in general terms - when I tried a more complex table with longer entries
per cell, they were all over the place.

As for pasting the other way around - Word to Excel - I still say that is a
no go. I tried a very simple time sheet and it was simply no good. However,
I am using 97.

I do, of course, respect your question and will value your response.

Ed

 

[Beth Melton]

Hi Edward,

Ah! Now I understand what you are referring to.

The default Paste format will convert the Excel worksheet to a Word
table. You can paste as an Excel Worksheet Object by using Edit/Paste
Special. But again, as with any embedded object you are limited one
'page'.

You can copy/paste Word data to Excel. It is seamless if you copy a
Word table, for other data Excel will attempt to find a common
delimiter in the Word data and parse it accordingly. For example if
you have a tab separated list at each tab it separate the data into a
cell and each paragraph mark will create a new row.

If you find the pasted Word data does not represent what you want in
the Excel worksheet then in Word you can use the Table/Convert/Text To
Table command specify the delimiters, under "Separate text at", and
then modify the Word table if necessary so it will copy/paste
seamlessly.

Do note that you need to know *how* your Word data is delimited and
you can not have a mix of delimiters. For example if you are working
with a tabbed list you need a single tab separating each data value
rather than multiple tabs on one line and a single tab on another, or
a line that uses spaces instead of a tab, etc.

If you need more information/examples of what I'm referring to along
with tips on how to 'clean-up' data so it does have consistent
delimiters take a look at this article:
http://mvps.org/word/FAQs/MailMerge/ConvertAdrsToDatafile.htm
--
Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/