How do I scale down an Excel worksheet to a single Word page?

[Guest]

When I attempt to copy and paste a range of cells in Excel worksheet into a
Word document, the data is successfully pasted; however, the Excel data does
not fit into the width of the Word document. It exceeds the margins and does
not print properly. How do I "reduce" the Excel data so that it will fit
properly into a single Word page? I am using Microsoft Office 2003. Thanks.

 

[Guest]

After selecting the cells in Excel, hold the the SHIFT key and pull-down:
Edit > Copy Picture

Back in the Word doc, just touch:
CNTRL-v

Because you have just pasted a picture in the Word doc, you can re-size it
like any picture.

 

[Guest]

Great! Thank you so much. This does exactly what I needed it to do. Do you
know if it is possible to link the Word document back to Excel to
automatically adjust for changes in Excel and still be able to scale (or make
it fit) in Word?

Thanks again. You have been a big help.

 

[Guest]

It is possible to link to a picture in Word, but you would still have to go
back to Excel to make the picture.

 

[Guest]

I thought that would probably be the case based on your initial answer.
Thanks again for all your help.

 

[Peo Sjoblom]

Do as follows: Click view>toolbars and select customize, then click the
commands tab, in the left pane scroll down to tools and in the right scroll
until you see a camera icon. Then just grab it with the mouse and drag it to
one of your menu toolbars, then close the dialogue box. This will give you a
snapshot than can be resized but it also links to the original workbook and
updates


--


Regards,


Peo Sjoblom

 

[Gord Dibben]

If you use the Camera Tool in Excel to take the picture, it will update in Word.

The SHIFT + Edit>Copy Picture is a static picture.

Camera Tool can be found at Tools>Customize>Commands>Tools.

Scroll down about 2/3 of the dialog box.

Drag to a Toolbar.

Select the range of cells and hit the Camera Tool icon to take a picture.

Paste to Word.


Gord Dibben MS Excel MVP

 

[Peo Sjoblom]

Same as I posted 50 minutes ago?

--


Regards,


Peo Sjoblom

 

[Gord Dibben]

Was not there when I downloaded messages for this group.

Gord

 

[Guest]

Thank you very much for your assistance.

Do as follows: Click view>toolbars and select customize, then click the
commands tab, in the left pane scroll down to tools and in the right scroll
until you see a camera icon. Then just grab it with the mouse and drag it to
one of your menu toolbars, then close the dialogue box. This will give you a
snapshot than can be resized but it also links to the original workbook and
updates


--


Regards,


Peo Sjoblom