|
|
#1
02-14-2015, 09:02 PM
|
|||
|
|||
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 
|
|
#2
02-14-2015, 09:47 PM
|
|||
|
|||
|
Copying rows from one spreadsheet to another
I found it...
Tabs: HOME/Merge & Center/Unmerge cells
|
|
#3
02-15-2015, 01:25 AM
|
||||
|
||||
|
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
__________________
Using O365 v2503 - 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
|
|
#4
02-15-2015, 08:23 AM
|
|||
|
|||
|
Merci, monsieur - l'homme de Bruxelles!
|
|
|
|
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 an Excel spreadsheet into Word with gridlines and a page break
|
Cheryl | Word | 2 | 09-04-2014 06:24 AM |
|
Using functions to restructure data in spreadsheet from rows to cols
|
ghumdinger | Excel | 1 | 07-28-2014 08:06 AM |
|
Delete Blank Rows (Cyrillic Text in Spreadsheet )
|
dozd | Excel | 1 | 02-22-2013 03:24 AM |
|
Adding rows and copying formulas
|
ejtoll | Word Tables | 1 | 12-05-2012 05:09 PM |
Windows 8 
Office 2010 64bit
Linear Mode
