Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-11-2013, 10:04 AM
Gitley Gitley is offline Losing rows when pasting split cells Windows 7 64bit Losing rows when pasting split cells Office 2007
Novice
Losing rows when pasting split cells
 
Join Date: Jan 2013
Posts: 1
Gitley is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 01-15-2013, 07:49 AM
OTPM OTPM is offline Losing rows when pasting split cells Windows 7 32bit Losing rows when pasting split cells Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

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
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Losing rows when pasting split cells 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
Losing rows when pasting split cells 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
Losing rows when pasting split cells merging rows and creating sub-rows gib65 Excel 2 12-09-2011 02:09 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:29 PM.


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