Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-02-2013, 05:33 AM
macropod's Avatar
macropod macropod is offline Pasting tables from Excel 2010 into Word 2010 - How to fix column widths? Windows 7 32bit Pasting tables from Excel 2010 into Word 2010 - How to fix column widths? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,516
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

Quote:
Originally Posted by GracieB View Post
Hi, thanks for the suggestion, but I'm afraid exactly the same thing happens if I paste it as an Excel item - still random column widths depending on the contents. Arg!
Are you sure the column widths for both pasted objects are the same in Excel? When pasted as an Excel item, the object does not become a Word table and is thus not subject to Word's table re-sizing behaviour.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #2  
Old 10-02-2013, 05:48 AM
GracieB GracieB is offline Pasting tables from Excel 2010 into Word 2010 - How to fix column widths? Windows 7 64bit Pasting tables from Excel 2010 into Word 2010 - How to fix column widths? Office 2010 32bit
Novice
Pasting tables from Excel 2010 into Word 2010 - How to fix column widths?
 
Join Date: Oct 2013
Posts: 4
GracieB is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
Are you sure the column widths for both pasted objects are the same in Excel? When pasted as an Excel item, the object does not become a Word table and is thus not subject to Word's table re-sizing behaviour.
Hi Paul,

Yes, I am working from one spreadsheet, with maybe 200 rows. If I paste one section from, say Row 20 to Row 35, then another from Row 150 to Row 170, they will often paste into Word with different widths, even though they are from the same sheet. is it possible that some glitch in the formatting of the spreadsheet has led to this problem, do you think?
Reply With Quote
  #3  
Old 10-02-2013, 05:57 AM
macropod's Avatar
macropod macropod is offline Pasting tables from Excel 2010 into Word 2010 - How to fix column widths? Windows 7 32bit Pasting tables from Excel 2010 into Word 2010 - How to fix column widths? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,516
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

Quote:
Originally Posted by GracieB View Post
I am working from one spreadsheet, with maybe 200 rows. If I paste one section from, say Row 20 to Row 35, then another from Row 150 to Row 170, they will often paste into Word with different widths, even though they are from the same sheet. is it possible that some glitch in the formatting of the spreadsheet has led to this problem, do you think?
I doubt the worksheet format is an issue (unless, perhaps, there are horizontally-merged cells involved.

In my testing I am unable to reproduce the behaviour you describe when pasting different blocks of cells from the same columns. Differences in text formatting, text wrapping & vertically-merged cells, for example, make no difference to the size of the pasted object or its column widths in Word.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Tags
columns, tables



Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2010 default column width 8.09 Jeff_J Excel 0 05-28-2013 11:56 AM
copying and pasting Excel tables into Word derohanes Word 1 01-24-2013 12:07 AM
Copy and pasting problem Word 2010 Sarah262 Word 3 08-16-2012 03:46 PM
Pasting tables from Excel 2010 into Word 2010 - How to fix column widths? Word 2010 and Excel 2010 Mail merge - multiple headers robby Word 3 04-18-2012 06:37 PM
Cutting and Pasting and Macro problems in Excel 2010 enkel Excel Programming 3 01-02-2012 10:15 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:14 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft