Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-05-2020, 02:47 PM
macropod's Avatar
macropod macropod is offline Insert Excel cells Word Table BUT Fit? Windows 7 64bit Insert Excel cells Word Table BUT Fit? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,515
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


I'm not quite sure what you're getting at. If the pasted content isn't formatted quite how you'd like it, you might try one of the other 'Paste Special (paste link)' options. Paragraph alignments, though, would be controlled within Word.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #2  
Old 02-07-2020, 06:31 PM
markg2 markg2 is offline Insert Excel cells Word Table BUT Fit? Windows 10 Insert Excel cells Word Table BUT Fit? Office 2019
Expert
Insert Excel cells Word Table BUT Fit?
 
Join Date: Nov 2009
Location: Evergreen, CO
Posts: 344
markg2 is on a distinguished road
Default

Don't bother, I sort of knew the post was unintelligible to others when posted.


No problem, I've got an easier one.


I have doc 1, which is comprised of a table having 2 columns and lots of row as generated by Word. Some rows are then merged to 1 cell, most are as initially generated by Insert/Table/select how many rows wide and how many down and a few that I've split the first column into 2 'sub' columns within the cell.


Then I created a new doc to experiment. I created the table just as I had done above. Then I created the split cell, 2 wide and tested the concept of copy from Excel, paste special as object and link.


After I understood how the procedure worked, I copied/pasted the experiment table into doc 1.



Problem: the vertical line that separates column 1 and column 2 is misaligned. The vertical separator is off by ~3/32" between that of doc 1 and the pasted experimental.


That shouldn't be. If both tables were created identically, automatically by Word then the centerline of the two columns should match perfectly.


In that they do not, is there a way to tell the complete doc 1 table (with pasted experiment table) to 'make the two columns' equal in width?


Mark
Reply With Quote
  #3  
Old 02-09-2020, 02:25 PM
macropod's Avatar
macropod macropod is offline Insert Excel cells Word Table BUT Fit? Windows 7 64bit Insert Excel cells Word Table BUT Fit? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,515
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 markg2 View Post
I didn't set out to insert a 'picture'. I followed online Word/Excel instructions and your assistance with the operation. As far as I knew and as stated by Word in the paste process, I was pasting, special, object, link to allow for an automatically updating table cell to a corresponding Excel cell.
The auto-updating is achieved via the 'paste link' option. Also I also said, though:
Quote:
Originally Posted by macropod View Post
If the pasted content isn't formatted quite how you'd like it, you might try one of the other 'Paste Special (paste link)' options. Paragraph alignments, though, would be controlled within Word.
Quote:
Originally Posted by markg2 View Post
I'm not interested in deleting resulting formatting codes or dealing with switches that should or shouldn't be present owing to an incorrect table creation. I'd just as soon get the table correct from the outset.
That's all very well but, unless you want to re-do all the copying & pasting, that's the easiest way of remedying the issue. For the future, do one copy and experiment with the different 'Paste Special (paste link)' options to see which one best meets your formatting requirements.
Quote:
Originally Posted by markg2 View Post
Is there a way, other than trial and error, guessing how many inches wide (which is one of the reasons I've abandoned tables previously) to initially set a new table comprised of 2 columns with equal widths and those widths added together come close to the L/R document margins thereby providing the most space within the two equal columns?
By default, Word will insert a table that fills the space between the margins and will evenly-space the columns. However, unless you edit the table properties to set the preferred widths for the table and its columns, plus uncheck the 'automatically resize to fit contents' option, none of those dimensions is fixed. The same applies to row heights.
Quote:
Originally Posted by markg2 View Post
Further, since you're implying that inserting the Excel cell as an object is in fact a picture and that is not the best method to copy/paste an Excel updating, numeric/formula cell, then what is the correct/better Word, paste special procedure?
See previous comments.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to insert page break when copying Excel table into PP? How set headers/footers in PP like Word? proja PowerPoint 0 09-16-2015 12:36 PM
Insert a Excel table in an existing PowerPoint table Vallin PowerPoint 1 03-09-2015 06:25 AM
How to insert a diagonal line across multiple cells in a Table? Joey Cheung Word Tables 1 10-10-2014 07:15 PM
Insert Excel cells Word Table BUT Fit? Insert a Word Table into an Excel cell Kapoof Excel 1 02-18-2014 02:12 PM
Insert Excel cells Word Table BUT Fit? Problems: Insert, Drag and drop table cells masterton Word 7 12-02-2013 12:05 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:04 PM.


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