Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-10-2020, 03:59 AM
Guessed's Avatar
Guessed Guessed is offline Pasting from Excel to Word 4 columns: data is truncated Windows 10 Pasting from Excel to Word 4 columns: data is truncated Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,185
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

I disagree - you did (inadvertently) set the cell sizes because you pasted from Excel, where the column width was specified.

Please test what I suggested earlier rather than just dismissing it.



Have a closer LOOK at your own screenshot. It says that the table cell width is 6'11" inches yet your ruler shows that the column it is trying to fit in is just over one inch.

If you change the section column count to 1 then you might see just how large the table column width is.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #2  
Old 08-10-2020, 05:07 AM
Andersn2 Andersn2 is offline Pasting from Excel to Word 4 columns: data is truncated Windows 7 64bit Pasting from Excel to Word 4 columns: data is truncated Office XP
Advanced Beginner
Pasting from Excel to Word 4 columns: data is truncated
 
Join Date: May 2012
Posts: 51
Andersn2 is on a distinguished road
Default

Quote:
Originally Posted by Guessed View Post
I disagree - you did (inadvertently) set the cell sizes because you pasted from Excel, where the column width was specified.

Please test what I suggested earlier rather than just dismissing it.

Have a closer LOOK at your own screenshot. It says that the table cell width is 6'11" inches yet your ruler shows that the column it is trying to fit in is just over one inch.

If you change the section column count to 1 then you might see just how large the table column width is.
Thanks for replying Guessed.

Please forgive me. Rather than dismiss what you said, I just did not understand what you meant or how to do it. This is all above my head. I'm just now getting an inkling of what you meant and it makes sense.

But, how do I "adjust the width of the table to no more than the width of the column"? Where do I do that? Do I do it in Excel or Word?

To keep the page count down, I need to cram the Excel data (it's all text) into 4 columns on the Word page.

Thank you for helping.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pasting linked data from excel into PowerPoint dcmontva PowerPoint 0 06-25-2019 02:11 AM
Pasting from Excel to Word 4 columns: data is truncated Trying to create an invoice by cutting and pasting data from one excel speadsheet to another famres Excel Programming 8 03-21-2015 05:59 PM
Pasting from Excel to Word 4 columns: data is truncated Copying and pasting values with unequal data columns grexcelman Excel Programming 5 12-05-2014 11:36 AM
Copying and pasting acount data into Excel as text will not reformat to a number or currency ncbergst Excel 3 09-04-2014 11:29 AM
macro for comparing data from 3 columns and pasting into another worksheet ashukla Excel 1 06-24-2009 05:01 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:12 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