Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-18-2013, 11:31 AM
JJG JJG is offline Copy Excel data into an existing Word Table Windows 7 64bit Copy Excel data into an existing Word Table Office 2010 64bit
Novice
Copy Excel data into an existing Word Table
 
Join Date: Dec 2013
Posts: 1
JJG is on a distinguished road
Default Copy Excel data into an existing Word Table

I have created a table in Word with approximately 16 columns. The data in the first row is basically my header/template for my table. The rest of the rows are blank. I have an excel table that I want to copy just the first 4 columns of data and x number of rows into my Word table I have set up. When I try to do this, the paste function either embeds an object or all the data appears in the first column and so on.

I need the data from the rows in Excel to be placed nicely in the first 4 columns, x number of rows and leave the other 12 columns blank.



I hope that makes sense, does anyone have an idea on how to copy from Excel and paste into an existing Table in Word?
Reply With Quote
  #2  
Old 12-18-2013, 05:41 PM
macropod's Avatar
macropod macropod is offline Copy Excel data into an existing Word Table Windows 7 32bit Copy Excel data into an existing Word Table 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

You can paste the Excel data into a new table, then drag it from there into the destination table.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Tags
copy, formatting, table

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy Excel data into an existing Word Table data from Excel into Word table ragesz Word Tables 1 09-29-2013 06:14 PM
Copy Excel data into an existing Word Table Modifying an existing table in Word janewayb Word Tables 1 04-08-2013 06:17 PM
Copy Excel data into an existing Word Table Cannot copy ->paste table structure but data pastes ok kangz Word 1 04-24-2012 04:05 AM
Copy Excel data into an existing Word Table How to copy automatically data from Excel file to Word file? fuchsd Word 6 10-25-2011 05:52 AM
Copy Excel data into an existing Word Table Excel data to Word table Jaymond Flurrie Word VBA 2 02-27-2011 07:42 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:41 AM.


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