#1
|
|||
|
|||
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
|
|||
|
|||
Copying rows from one spreadsheet to another
I found it...
Tabs: HOME/Merge & Center/Unmerge cells |
#3
|
||||
|
||||
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 |
#4
|
|||
|
|||
Merci, monsieur - l'homme de Bruxelles!
|
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 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 |