Thread: [Solved] Copy/paste from Excel to Word problems!
View Single Post
 
Old 06-14-2011, 05:21 PM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2007
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
Actually, pasting an Excel range into Word, preserving the formatting and allowing for re-scaling is quite simple: Select & copy the Excel range and then, in Word, use Paste Special > Microsoft Excel Worksheet Object. If you want the Excel workbook to be linked to the Word document, check the 'paste link' option also. With this, you can re-scale the Excel object to your heart's content. You can even re-scale the horizontal and vertical dimensions independently.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote