Free Microsoft Excel 2013
Quick Reference
Free Microsoft 2013 Quick Reference Guide

Free Microsoft Excel 2013 Quick Reference

This operation requires the merged cells to be identically sized

I am getting this error when I select a merged cell and an adjacent cell and try to drag them down the page (the lower right hand corner grab, to have it extend the formulas into the cells you drag over)

I only see the solution to remove the merged cells, but I cannot remove the merged cells, as it would disturb the formatting of the spreadsheet.

I can select the merged cell and drag it individually, but just not when I select the merged cell in addition to other cells. How do I go about fixing this, so I can select the merged cells and the adjacent non merged cells and drag down the page.

-Andrew


Post your answer or comment

comments powered by Disqus
I copied a table off the internet (last name, first name, company name, State, phone number and email = total of 5 columns) 600 rows.

I copied it, first to WORD and then from Word I copied & pasted all 5 columns at once to Excel. The beginning of the problem stated when pasting into Excel. What looked like 600 rows in the Word table turned out to be 1200 rows in Excel. Each row became two rows in Excel. The first four columns we two rows , merged into one by column. the 5th column was the phone number and email address, stacked, each in its own row. I copied the phone # and email column and then pasted it into another column (F) to end up with six columns. When I pasted the data into column F, I did so by staggering the paste so that the email address that was above the phone number in column E, ended up in column F after the phone number in the same row as all the other data. Next I manually deleted each row that was not needed (i.e the row with the email address and pasted phone number).

Appearances are what I wanted and that's what I got i.e. one record per row, which was comprised of six columns; columns A=Last name, B=First name, C=company name, D=State, E=phone number & finally column F=email address.

Here's the problem; I can't sort anything - nohow. When I tried sorting column A, ascending so I could end up with an Alphabeticaly sorted list by Last name I got "DOINKED" the error window that popped up said, "This operation requires the merged cells to be identically sized." It makes no difference what column I try and sort, each time I try a new column just to see if I could sort on it, I get "DOINKED" Anybody got any ideas? Please; I hope someone does.

Please hurry, as I'm a few seconds away from pulling my hair out.

THANX in advance for your assistance.
Scott

I have a spreadsheet with three rows of IDENTICALLY SIZED merged cells
consisting of 1 row and 2 columns, stacked in rows. The row height for all
three rows is 40. The column widths a D, 26.57 E, 5.14. The three cells
represent the top three issues on a summary sheets and so the contents
frequently move up and down. I cannot copy and paste. Whenever I try, it says
"This operation requires the merged cells to be identically sized". But they
are identically sized! What else could it be referring to other than the row
height and column widths? Is there some other property Excel wants me to make
equal that it calls "size"?

I have a spreadsheet with three rows of IDENTICALLY SIZED merged cells
consisting of 1 row and 2 columns, stacked in rows. The row height for all
three rows is 40. The column widths are: D, 26.57 E, 5.14. The three cells
represent the top three issues on a summary sheets and so the contents
frequently move up and down. I cannot copy and paste. Whenever I try, it says
"This operation requires the merged cells to be identically sized". But they
are identically sized! What else could it be referring to other than the row
height and column widths? Is there some other property Excel wants me to make
equal that it calls "size"?

When I try to sort my data, I get this error: "This operation requires the merged cells to be identically sized". Does anyone know the fix so the data can be sorted?

I've got a new problem. When I try to sort my list which has company, city
and state Excel won't sort it I keep getting the message that "this operation
requires that merged cells must be identically sized". What merged cells? I
did nothing that I know of to prompt this message. No matter what I try it
won't do it. This is Excel 97. Can someone tell me why this is happening?
Thanks,
Catt

I've got a new problem. When I try to sort my list which has company, city
and state Excel won't sort it I keep getting the message that "this operation
requires that merged cells must be identically sized". What merged cells? I
did nothing that I know of to prompt this message. No matter what I try it
won't do it. This is Excel 97. Can someone tell me why this is happening?
Thanks,
Catt

I'm cutting data from multiple sheets and pasting it into one, using Paste
Values. This has been going OK for a while, but then when I cut data from one
of the sheets, I get the error:

This operation requires the merged cells to be identically sized.

I have no idea what any of these terms mean. I don't know what "merged
cells" are in this context, nor can I figure out where such a thing may be. I
don't know what "identically sized" means, because I'm selecting a single
cell, which is typical for a paste operation. In fact, it's not even clear
what "this operation" is referring too, and I have a feeling it's not "paste".

Anyone know what this means and how to fix it? There's no help on it that I
can find.

Maury

Does anybody know how to identify which cells in a worksheet are merged?

i have about 3,000 rows of data from a company reporting system and am trying to sort the data before i go any further, when i try to sort it i get the following message: this operation requires the merged cells to be identically sized.

is there any way of getting excel to sort this or do i need to do it manually?

your helpwould be much appreciated.
JP

I have a small recorded macro to "sort" a data table... the table has a two row header that most (but not all) columns have merged cells across the two rows...
The sort excersize works fine when done manually in Excel, but when I run the macro, I get;

"Run-time error '1004':
This operation requires the merged cells to be identically sized."

Is there a way around this problem without removing the merged cells (ie. going to a single row header)?

I received a large xl-file, in which I want to execute some sorting
operations. However, I get the error message that "this operation requires
the merged cells to be identically sized". I guess some cells are merged, but
does anybody know how I can quickly find the merged cells?

When attempting to sort spreadsheet, I receive the following error.
(This operation requires the merged cells to be identically sized) How
do get past this error?

When you use past special | values, and try to paste a large bunch of data
with merged cells into another sheet, it will not let you paste just the
values. This requires un-merging the cells. The problem that I have with
this, is that the error message makes NO sense. It says "This operation
requires the merged cells to be identically sized". Well, guess what? They
are!!! I just copied them in from another worksheet. I even used paste
special | column widths to ensure that the were indeed the same size. I
don't understand what the big deal is anyway? If Excel can paste formulas
into merged cells, why not values? I think that this should be fixed.
Thanks!

FYI, I am a highly advanced user of excel and the obvious workaround is to
unmerged the cells, paste and remerge them. It is just a pain in the butt
and like I said, if you can paste formulas using merged cells, why not
values? It makes no sense!

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

I received a large xl-file, in which I want to execute some sorting
operations. However, I get the error message that "this operation requires
the merged cells to be identically sized". I guess some cells are merged, but
does anybody know how I can quickly find the merged cells?

Hi everyone,
I'm having trouble sorting some data. I select the data i want sorted, then choose how to sort the data, but when i click "ok" it says, "this operation requires the merged cells to be identically sized."

Unfortuantely i did not create this spreadsheet. I am unable to locate ANY merged cells. The only difference i was able to find was that some rows were different heights. I have formatted all rows to be the same height and still no luck. Any ideas on how to locate the merged cells? Suggestions?

Thanks
HQH2O

When you use past special | values, and try to paste a large bunch of data
with merged cells into another sheet, it will not let you paste just the
values. This requires un-merging the cells. The problem that I have with
this, is that the error message makes NO sense. It says "This operation
requires the merged cells to be identically sized". Well, guess what? They
are!!! I just copied them in from another worksheet. I even used paste
special | column widths to ensure that the were indeed the same size. I
don't understand what the big deal is anyway? If Excel can paste formulas
into merged cells, why not values? I think that this should be fixed.
Thanks!

FYI, I am a highly advanced user of excel and the obvious workaround is to
unmerged the cells, paste and remerge them. It is just a pain in the butt
and like I said, if you can paste formulas using merged cells, why not
values? It makes no sense!

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

I have a pair of workbooks in which one calculates a number of values and I want to store the values only in the other.

I would expect to be able to highlight the range of the calculated cells in the source workbook, Copy and then Paste Special | Values in the other.

Both the source and the target contain some merged cells. When I try to do the paste, it complains that "this operation requires the merged cells to be identically sized".

They are identically sized.

I have even done Paste Special | Column Widths to guarantee they are identically sized. It doesn't complain about the merged cells then; in fact, it doesn't complain about the merged cells with any of the other paste operations, only with Values.

I have been able to repeat the behaviour with a very simple example. See the two attached sheets. Try pasting Values only of the range $B$2:$D$4 from either one to the other.

When I first created the samples they worked. What seemed to triggered it is I changed one of the merged column widths by one pixel, tried expecting it to fail (and it did), changed that column width back again and it hasn't worked since. As I said, I even tried pasting the Column Width to the target, which it appeared to do successfully, but it hasn't helped.

Now, the attached examples are only to show the principle of the problem. They are very simple and there would be a myriad alternative work-arounds for them. In my original case though there are many formulae over a much larger range and I want other people to be able to paste values without having to follow complicated instructions, so I am not looking for work-arounds unless someone has a mind-numbingly simple one that my numb mind has overlooked.

The only other way of solving the problem that I can think of would be to write a macro that copies cell values individually, but I'd rather not do that because I know these people: they will get narky about having to enable macros. It will be "against organisation policy" or something.

Is there any way of resetting the target workbook so that it will receive the values from the source?

Hey all,
OK I have another problem, I'm using excel 2002. When I try to sort something, I get a "this operation requires the merged cells to be identically sized" message. Now I know how to unmerge all the cells, but is there something that will let me leave them MERGED while still able to sort? I can't unmerged them or my headings will look weird and my clients won't accept it. This document is updated weekly too so unmerging and merging each time I sort is not an option for me because it's over 1000 pages. Thanks for the help in advance!

I export a file out of our accounting program into GP and when I try to print from GP I get this message
This operation requires the merged cells to be identically sized could someone help me what does this mean

thank you

Hi all,

My first post here and to warn I am a relative newbie at Excel (compared to most of the users on the site).

I need help sorting columns that have multiple rows in them. The reason for this is to keep the columns within one page for printing. For example:

Column one has three rows of info : Name, number & email address
Column two - five have one row of info, but merged over three cells to keep same size as the three rows needed for column one
Column six & seven also have three cells merged (downwards / rows)

Now when I try to sort (using the Filter button) by column, it says "This operation requires the merged cells to be identically sized"

If I unmerge Column One, Six & Seven, then when I filter it won't include the info needed.

Is there a way I can merge a cell to "bluff" Excel into thinking it is merged, yet keeping the three cells seperate?

Or is there any other suggestions you can think of?

Thank you in advance and please let me know if there is any other info required (in case I haven't made sense above)

Gents and ladies,

(Note: using MS Excel 2000)

I have an excel sheet which is highly formatted. In particular, many cells are merged cells 3 and 4 cells long.

What I am trying to do is make a second sheet which is formatted exactly like the first sheet, and then quickly copy all the cells from one to another. **BUT** I do not want a simple copy per se. Rather, I want the second sheet to be a referenced copy.

So for example .....

If cell A1 of the original sheet (lets call it "Original sheet") is the value 27 (or a forumla which results in 27), I want cell A1 in the copied sheet to be "='Original sheet'!A1" and so on.

So what I am shooting for is to have every cell in the second sheet be a formula reference from the first sheet. So if i make a change in the first sheet, i get the exact change in the second sheet becuase the second sheet is nothing more than references to the same cell in the first sheet.

One would think that since the second sheet is an exact "format replica" of the first sheet (merged cells and all), that I could simply do cell A1 as an "='Original sheet'A1!" and then drag out the rest of the formulas to make a fully refernced replica of the Original sheet. but i get a "This operation requires the merged cells to be identically sized" error.

Is there a qiuck method to making this fully referenced replica sheet?

I have been dragging across cells to duplicate formula and formatting, however, all of a sudden when i try to do this i am getting an error message which reads 'this operation requires merged cells to be identically sized'

I have ensured that all cells are the same size across the area i am trying to duplicate my formulas but the error is still occuring.

Any ideas please?

hi all,

im having trouble copying and pasting from one tab to another.

when i copy the section from the first tab and attempt to paste in the second im am faced with the error message "This operation requires te merged cells to be identically sized"

Is their a way i can copy across the formatting and values without having to unmerge all the cells?

many thanks,

In the area A23:G30, each row contains merged cells of column B, C, D, E
and F apart from each other row in the area. I get a "This operation
requires that merged cells to be identically sized" error when running
this macro. Even using the Data/Sort from the File menu gives me this error.

How would I sort an area containing rows with merged cells? Also, the
cells must remain (or return to being) merged after this operation.

I appreciate the previous help concerning clearing the contents from
merged cells using ActiveCell relative references. Unfortunately, my
email/newsgroup client, for whatever reason, will not display that
previously posted newsgroup thread, so I must start another. Will fix.

Also, the Header parameter line is not broken in my code but just
displays that way in this message formatting.

'''''''''''''''''''''''''''''''''''''''''''''''''' '
Sub SortData()

Application.ScreenUpdating = False

Range("A23:G30").Select
Selection.Sort _
Key1:=Range("A23"), Order1:=xlAscending, _
Key2:=Range("F23"), Order2:=xlAscending, _
Header:=No, OrderCustom:=1, MatchCase:=False,
Orientation:=xlTopToBottom

ActiveCell.Select

Application.ScreenUpdating = True

End Sub

''''''''''''''''''''''''''''''''''''''''''''''''''

I was given a large spreadsheet (737 rows and 45 columns) to clean up before
transferring into a database file. Certain cells text, others numbers,
emails, etc. and some are color coded to identify a specific distribution
process.

Whenever I try to sort the data, the following message shows up and it won't
allow me to sort. "The operation requires the merged cells to be identically
sized"

I have spent the better part of a day trying to find the merged cells, but
have failed. Is there some way to find merged cells with the sheet without
clicking on every cell individually? Is there some other way to accomplish
the task for sorting? Thank you.


No luck finding an answer? You could always try Google.