Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-14-2015, 09:02 PM
Colonel Biggs Colonel Biggs is offline Copying rows from one spreadsheet to another Windows 8 Copying rows from one spreadsheet to another Office 2010 64bit
Advanced Beginner
Copying rows from one spreadsheet to another
 
Join Date: Jul 2010
Posts: 52
Colonel Biggs is on a distinguished road
Default Copying rows from one spreadsheet to another

When attempting to copy several rows from one spreadsheet to another, I receive an error message that says my action "requires the merged cells to be identically sized." In this case, all of the columns are of a different width. I have encountered this before and, if I recall correctly, there is a method for undoing the merged columns in the spreadsheet into which the data is to be copied. In other words, the spreadsheet into which I wish to Paste the data contains merged/linked columns.

Thanks for any assistance.

Gordon
Houston, TX
Reply With Quote
  #2  
Old 02-14-2015, 09:47 PM
Colonel Biggs Colonel Biggs is offline Copying rows from one spreadsheet to another Windows 8 Copying rows from one spreadsheet to another Office 2010 64bit
Advanced Beginner
Copying rows from one spreadsheet to another
 
Join Date: Jul 2010
Posts: 52
Colonel Biggs is on a distinguished road
Default Copying rows from one spreadsheet to another

I found it...

Tabs: HOME/Merge & Center/Unmerge cells
Reply With Quote
  #3  
Old 02-15-2015, 01:25 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Copying rows from one spreadsheet to another Windows 7 64bit Copying rows from one spreadsheet to another Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

FYI, except for pure cosmetic purposes, merging cells should be avoided.
If necessary you can use Format - Alignment - Horizontal - Center across selection ( if memory serves) Same effect , no drawbacks
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #4  
Old 02-15-2015, 08:23 AM
Colonel Biggs Colonel Biggs is offline Copying rows from one spreadsheet to another Windows 8 Copying rows from one spreadsheet to another Office 2010 64bit
Advanced Beginner
Copying rows from one spreadsheet to another
 
Join Date: Jul 2010
Posts: 52
Colonel Biggs is on a distinguished road
Default

Merci, monsieur - l'homme de Bruxelles!
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Trying to import specific data from one spreadsheet to another, without matching rows Wynka Excel 0 11-26-2014 09:33 AM
Copying rows from one spreadsheet to another Copying an Excel spreadsheet into Word with gridlines and a page break Cheryl Word 2 09-04-2014 06:24 AM
Copying rows from one spreadsheet to another Using functions to restructure data in spreadsheet from rows to cols ghumdinger Excel 1 07-28-2014 08:06 AM
Copying rows from one spreadsheet to another Delete Blank Rows (Cyrillic Text in Spreadsheet ) dozd Excel 1 02-22-2013 03:24 AM
Copying rows from one spreadsheet to another Adding rows and copying formulas ejtoll Word Tables 1 12-05-2012 05:09 PM

Other Forums: Access Forums

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