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.

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.
--
Gary''s Student - gsnu200747


"Sousixer" wrote:

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.

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.


"Gary''s Student" wrote:

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.
--
Gary''s Student - gsnu200747


"Sousixer" wrote:

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.

It is possible to link to a picture in Word, but you would still have to go
back to Excel to make the picture.
--
Gary''s Student - gsnu200747


"Sousixer" wrote:

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.


"Gary''s Student" wrote:

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.
--
Gary''s Student - gsnu200747


"Sousixer" wrote:

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.

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

"Sousixer" wrote:

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.


"Gary''s Student" wrote:

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.
--
Gary''s Student - gsnu200747


"Sousixer" wrote:

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.

Do as follows: Click viewtoolbars 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


"Sousixer" wrote in message
...
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.


"Gary''s Student" wrote:

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.
--
Gary''s Student - gsnu200747


"Sousixer" wrote:

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.

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

The SHIFT + EditCopy Picture is a static picture.

Camera Tool can be found at ToolsCustomizeCommandsTools.

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

On Fri, 28 Sep 2007 05:58:01 -0700, Sousixer
wrote:

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.


"Gary''s Student" wrote:

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.
--
Gary''s Student - gsnu200747


"Sousixer" wrote:

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.

Same as I posted 50 minutes ago?

--


Regards,


Peo Sjoblom



"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
If you use the Camera Tool in Excel to take the picture, it will update in
Word.

The SHIFT + EditCopy Picture is a static picture.

Camera Tool can be found at ToolsCustomizeCommandsTools.

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

On Fri, 28 Sep 2007 05:58:01 -0700, Sousixer
wrote:

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.


"Gary''s Student" wrote:

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.
--
Gary''s Student - gsnu200747


"Sousixer" wrote:

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.

Was not there when I downloaded messages for this group.

Gord

On Fri, 28 Sep 2007 08:20:46 -0700, "Peo Sjoblom" wrote:

Same as I posted 50 minutes ago?

Thank you very much for your assistance.

"Peo Sjoblom" wrote:

Do as follows: Click viewtoolbars 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


"Sousixer" wrote in message
...
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.


"Gary''s Student" wrote:

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.
--
Gary''s Student - gsnu200747


"Sousixer" wrote:

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.