Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
carolsue1313
 
Posts: n/a
Default Excel data not transfering to Word. Colums are expanded.

When copying and pasting data with colums from Excel to Word the colums
appear expanded and my picture is off the sheet. Word thinks it is ok. Word
will not shrink to fit.
  #2   Report Post  
Eddie O
 
Posts: n/a
Default

If you don't mind pasting it as a picture instead of an Excel worksheet
object (which Word defaults to), you could ensure that it shows up the same
as it appears in Excel by pasting it as a picture.
After copying from Excel, in Word select Edit / Paste Special, and then
choose one of the picture formats. If the resulting picture is still going
off the screen in word, you could resize the picture to make it smaller, or
just select fewer columns in Excel.

-Eddie O

"carolsue1313" wrote:

When copying and pasting data with colums from Excel to Word the colums
appear expanded and my picture is off the sheet. Word thinks it is ok. Word
will not shrink to fit.

  #3   Report Post  
carolsue1313
 
Posts: n/a
Default

Thanks for the info Eddie.





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pasting Word table cell with paragraph markers into single Excel c Steve Excel Discussion (Misc queries) 1 June 16th 05 11:26 PM
exporting excel worksheet to word morrowkd Links and Linking in Excel 1 May 11th 05 11:23 PM
Data Automation from Excel to Word Adam Excel Discussion (Misc queries) 3 February 22nd 05 02:43 PM
combined cell data from Excel to Word (2003) Adam Excel Discussion (Misc queries) 2 February 14th 05 03:29 PM
Pulling data from 1 sheet to another Dave1155 Excel Worksheet Functions 1 January 12th 05 05:55 PM


All times are GMT +1. The time now is 01:04 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"