#1
|
|||
|
|||
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? |
#2
|
||||
|
||||
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 |
|
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 |
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 |