View Single Post
 
Old 09-22-2020, 07:43 AM
2vbr 2vbr is offline Windows 10 Office 2013
Novice
 
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