Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-22-2020, 07:43 AM
2vbr 2vbr is offline Stop Word from repeating tables when pasting from Excel Windows 10 Stop Word from repeating tables when pasting from Excel Office 2013
Novice
Stop Word from repeating tables when pasting from Excel
 
Join Date: Sep 2020
Posts: 4
2vbr is on a distinguished road
Default Stop Word from repeating tables when pasting from Excel

Let's say I have 3 cells of data in Excel, in a column:

One
Two
Three


I have a Word document with a column of tables, one table for each cell. If I copy the three excel cells, and highlight exactly three tables, I can paste and everything is fine.

But let's say I have six tables. If I highlight those six and paste, the three cells will begin repeating:

One
Two
Three
One
Two
Three



Is there a way to turn off this "repeat from clipboard" feature in Word? Sometimes I have 1200 cells to paste into Word, and it's troublesome to highlight exactly 1200 tables to prevent the repeating issue.

Right now I copy 1200 cells, highlight a little over 1200 tables in Word, then paste, then manually remove the initial repeating ones. But that's just so damn annoying.

Is it possible for Word to only paste what's in the clipboard, with no repeats?
Reply With Quote
  #2  
Old 09-22-2020, 06:21 PM
Guessed's Avatar
Guessed Guessed is offline Stop Word from repeating tables when pasting from Excel Windows 10 Stop Word from repeating tables when pasting from Excel Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
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'm going to assume when you say 'exactly three tables', you actually mean exactly three cells in one Word table. Thereafter I assume you interchangeably use tables to mean cells.

This behaviour is quirky and can be complicated by conversion of formats (Excel to Word) and selection of cells vs selection of rows vs selection of tables.

The method I use is to do two copy paste operations. The first paste requires a conversion from Excel to Word format. I would do this by pasting firstly into a temporary empty document. I then add an extra cell into that table (since copying an ENTIRE table has different behaviour), select the cells I want and copy, then position my cursor in the first cell of the target table where I want to paste (not selecting cells) and do the Paste. If there isn't enough rows below that insertion point, Word automatically adds them.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pasting more than 4 cells into Word tables ignores cell divides 2vbr Word Tables 0 09-21-2020 08:16 PM
Word custom proxy settings & stop re-downloading images when pasting alex100 Word 1 07-20-2020 09:50 AM
Stop Word from repeating tables when pasting from Excel Copy + Pasting Excel Tables in word have 8pt spacing Jiing Chiang Word Tables 4 01-14-2016 05:43 PM
Pasting tables from Excel 2010 into Word 2010 - How to fix column widths? GracieB Word 7 10-02-2013 06:24 AM
copying and pasting Excel tables into Word derohanes Word 1 01-24-2013 12:07 AM

Other Forums: Access Forums

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