Placing Excel Sheets into a Word Document

billwcsi

New Member
Joined
Mar 17, 2002
Messages
12
I have a sheet in excel with graphs and text. I want to place this sheet as it appears in excel into a Word document. I want it to take up exactly 1 page in the Word document. In the excel document I need to reduce it to 71% of its normal size for it to print on 1 page. When I paste this into Word it takes up 1 1/2 pages. How can I reduce this in Word? Thanks for your helpQ
 

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop
From the word helpfile:
Prevent a document from flowing onto an additional printed page:

Try to reduce the amount of text that appears on the last page. If only a small amount of text appears on the last page of a short document, you may be able to reduce the number of pages by clicking Shrink to Fit in print preview. This feature works best with documents that contain only a few pages, such as letters and memos. In order to shrink the document, Word decreases the font size of each font used in the document. You can undo a Shrink to Fit operation by clicking Undo Shrink to Fit on the Edit menu. However, after you save the document and close it, there is no quick way to restore the original font size.
 
Upvote 0
On 2002-04-11 09:48, billwcsi wrote:
I have a sheet in excel with graphs and text. I want to place this sheet as it appears in excel into a Word document. I want it to take up exactly 1 page in the Word document. In the excel document I need to reduce it to 71% of its normal size for it to print on 1 page. When I paste this into Word it takes up 1 1/2 pages. How can I reduce this in Word? Thanks for your helpQ

Hi billwcsi:
If you want to insert part of a worksheet into a Word document, one of the ways is to either embed or link a picture of that part into Word ... steps:
1)in Excel, hilite the area you want to take a picture of
2)hold the SHIFT key then EDIT|COPY_PICTURE
(te picture is now on the clip board)
3)now for pasting the picture in Word, while holding the SHIFT key EDIT|Paste_Special|Picture

Now as far as sizing the picture to accomodate on one page in Word that is not a problem -- click on the picture, use the handles around the picture to enlarge it, reduce it, make it skinnier, make it fatter (that is changing the aspect ratio) to your liking.
HTH
Please post back if it works for you ... otherwise explain a little further and let us take it from there!
 
Upvote 0
Thanks Al. I appreciate your help. I tried that and my document is too large. I expect I'll have to try reducing the excel document and then paste it over and repeat the process.

Bill
 
Upvote 0

Forum statistics

Threads
1,213,536
Messages
6,114,208
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top