Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-04-2020, 05:52 AM
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 Insert Excel cells Word Table BUT Fit?

I wish to insert (paste special/Object/Link) 3 columns of an Excel worksheet (the 3rd column having values and an addition formula at the bottom) into an existing Word table.


I've tried this many times before and have given up trying to figure out how to get the imported data to 'fit' properly within the target cell.


Two questions:


1. Would someone provide an information link that explains how to do the above wherein Word/Excel will automatically adjust in size and format?




2. Does the source Excel file and the target Word file need to be in the same directory for the Word table to automatically adjust to changes in the Excel cells?


Thanks,


Mark
Reply With Quote
  #2  
Old 02-04-2020, 02:09 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: 21,956
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

1. Insert cell-by-cell links in Word to the individual Excel cells.
2. No.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 02-05-2020, 06:40 AM
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

Did so, works & thanks.


The destination Word table is two columns wide. Without changing that format for the entire table, I need more cells in column A for the pasted Excel data. I split column A row whatever in half. I pasted text from Excel to Aa and numbers/formula to Ab. Very nice. The pasted object retains Excel's format. So in Word table Ab for example, the result is the pasted number sitting within a fine cell outline and the 'remainder' of the Word table's Ab width as excess, blank space. Is what I describe what you would expect and live with or is there a further step I'm missing that, once I've pasted the Excel cells to Aa and Ab, the pasted objects can be told to automatically fit the target table widths?


Mark
Reply With Quote
  #4  
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: 21,956
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
  #5  
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
  #6  
Old 02-07-2020, 08:11 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: 21,956
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

Without seeing both tables, it can be difficult for anyone to diagnose the issue. Can you attach a document to a post with those tables (delete anything sensitive)? You do this via the paperclip symbol on the 'Go Advanced' tab at the bottom of this screen.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #7  
Old 02-08-2020, 06:28 AM
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

I'm okay ending up with unequal columns (the two main Word table columns) after the paste provided there's a way of equalizing all the resulting column widths afterward.


And curiously, as asked before, if both the original table of 2 columns and the experimental table of 2 columns were both created by Word, automatically, in the exact same way--I would think that the left and right column in both instances would be precisely the same width--which they are not.



Secondarily, I think now you can see what I previously meant about 'excess' space after the paste of the Excel object. Look to the right of '30,000'.


Btw, I looked up Macropod--learn something every day ;-)


Mark
Attached Files
File Type: docx Example upload to Macropod.docx (32.6 KB, 7 views)
Reply With Quote
  #8  
Old 02-08-2020, 02:43 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: 21,956
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

The alignment problem is due to your use of a table that doesn't have the column widths defined with a 'preferred width' (even the table lacks a 'preferred width') and the fact you've inserted the links as pictures. If you press Alt-F9 to expose the field codes and change the \p switches to, say, \t and delete the \* MERGEFORMAT switches wherever they appear, you'll get outputs whose formatting you can manage in Word.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #9  
Old 02-09-2020, 07:40 AM
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

<<<<<table that doesn't have the column widths defined with a 'preferred width' (even the table lacks a 'preferred width')<<<<<


Okay, I incorrectly presumed, hardly ever using tables, if I Insert/Table/click boxes wide & down, that what you point to as 'even lacks...' would have been provided as basic formatting by MS using their 'automatic' table or at least be prompted in the process given the apparent importance of the format.



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. Intuitively, I wouldn't expect a picture to equate to a pasted Excel, updating formula.



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.



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?


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?


Mark
Reply With Quote
  #10  
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: 21,956
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 02:28 PM.


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