Want to copy range from Excel to Word, but shrink!

  WhenHeavenTouchesEarth 10:48 05 Oct 2005

Hi all, I have a range of cells in Excel which displays in its entirity in terms of width, however is longer than the Excel screen.

I want to get this range of cells into a report in Word, but I want to be able to resize it to fit nicely. Is there any way of doing this?

I don't want to go through the process of using 'PrtScr' and then editing the image, then pasting it into Word.

I don't want to have to resize the table wand the font in Word, as seperate entities.

I'd like to be able to resize the pasted Excel data in Word.

Any ideas whether I can do this, and how?

  scotty 11:44 05 Oct 2005

I think you are wanting to paste the Excel data into word as an image which you can then resize? Note that if you do this you will not be able to edit the data.

Copy the cells in Excel then use "Paste Special" from the Edit menu and paste as a Picture. The resulting image can then be selected and resized by dragging the markers at the corners of the image.

  WhenHeavenTouchesEarth 12:10 05 Oct 2005

Thanks Scotty, that should do it!

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

iMac Pro review

Illustrator Charles Williams on how to create magazines and book covers

iMac Pro review

Les meilleures prises CPL (2018)