#1
|
|||
|
|||
Losing rows when pasting split cells
I have a table (4 columns, 17 rows) in which I have split each cell of the third column into six smaller rows. Whenever I cut and paste any of the larger rows that contain such a split cell, the information within that cell is lost and only the top row of the split cell is copied over.
This happens whether I paste the row back into the table, or anywhere else in the document. If my terminology makes it hard to visualize the problem, please let me know so I can somehow make the situation more clear. I'll really appreciate any help. |
#2
|
|||
|
|||
Hi
Here is my solution which works fine for me: 1. Highlight the first 3 columns with your mouse (to include each of the six smaller rows in column 3). 2. Then to pick up column four use Ctrl+Shift+Right Arrow. This will highlight column four also. 3. Enter Ctrl+C to copy. 4. Right click in column one where you want to paste the copied row. 5. Under Paste Options click on the third box. You should find that your row will paste exactly as copied. Good luck. Tony |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Word Macro to find and delete rows that contain adjacent cells containing "." | AlexanderJohnWilley | Word VBA | 7 | 11-08-2012 10:15 AM |
borders disappear from merged cells when pasting from excel | joba | Word | 0 | 09-10-2012 11:35 AM |
Macro to delete rows with all empty cells | ubns | Excel Programming | 2 | 08-14-2012 02:01 AM |
How to auto-split a table at FULL rows? | pstein | Word | 5 | 03-27-2012 02:48 PM |
merging rows and creating sub-rows | gib65 | Excel | 2 | 12-09-2011 02:09 PM |