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

Free Microsoft Excel 2013 Quick Reference

error message: merged cells must be same size

scanned part and entered part of contact list alpha in Excel 2002. Need to
sort by state which is separate column. Keep getting error message: merged
cells must be same size. Can't see any difference. How to find out what
cells are different? Or is there a different way to sort this list than
using the "Sort" function?

Thanks!


Post your answer or comment

comments powered by Disqus
scanned part and entered part of contact list alpha in Excel 2002. Need to
sort by state which is separate column. Keep getting error message: merged
cells must be same size. Can't see any difference. How to find out what
cells are different? Or is there a different way to sort this list than
using the "Sort" function?

Thanks!

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 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?

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"?

How I sort data in Excel, it keeps saying "merged cells must be identical
size?" I know what merged cells are and I'm pretty sure I DON'T have any in
the data I'm trying to sort. I've sorted data before and never run into this.
Is there a way I can check for what Excel is considering to be merged cells,
i.e. a find for merged cells?
I'm using Excel 2002 on Win XP Pro.

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"?

How I sort data in Excel, it keeps saying "merged cells must be identical
size?" I know what merged cells are and I'm pretty sure I DON'T have any in
the data I'm trying to sort. I've sorted data before and never run into this.
Is there a way I can check for what Excel is considering to be merged cells,
i.e. a find for merged cells?
I'm using Excel 2002 on Win XP Pro.

I've got a spreadsheet which has a section (A24:J42) that has six columns.
Columns B-F have been merged in this data section, but not so in A1:J23. When
I try sorting the data section I am only presented with columns (as a whole)
to sort. Obviously, I'm getting the message "merged cells must be identical
size".

I've looked through past postings about this, and done some Internet
searching, and the best I can find is how to unmerge the merged cells and the
sort will work.

Yup! It works just fine, but the problem is my data section in columns B-F
contain data only in column B. When I go to merge those cells, the only way
to do it is by individual rows.

While I only have a few rows in this worksheet, it only takes a minute or
so, but it isn't being done in one action. What if this table grows and I
have several hundred rows in this data section. Actions of unmerging and
sorting are very possible, but to have to go back and merge cells B-F in each
row is time consuming, prone to error, and goes against the grain of what
computers are supposed to do for us.

Any idea how to resolve this problem? Is there a way to break worksheets
into sections (like Word allows for) so that individual actions in each
section can be done?

Thanks
Gil

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'm desperate for an answer to this question!!! What does this error message
mean and how do i fit it???!!

Doing mutliple regression analysis and I transformed all my data to logs and
tried to run a regression on the data and I've swithched around the columns
the data appears in, filled in all blanks spaces in data, and everything
else I could think of and I still keep getting this error message Input range
must me be contiguous reference :S... I don't know what else to do...any
suggestions???? Can I not do a multiple regression analysis on non-linear
data??? Is it that I transformed all the data to Logs?? Please Help!!

I'm trying to sort upon a given column and I get the error message stating
that "Merged cells must be of the same size."

I know what merged cells are, but the problem is, I cannot find ANY cells in
the column in which I am sorting that are merged. So does this rule apply to
ANY CELL in ANY column? If so, how do I bypass or shut off this feature so
that I can perform what I thought was going to be a simple sorting of date on
a single field?

Hi. someone sent me what looks like a run of the mill excel file . When I
try to sort it I get a message saying the "operation requires merged cells to
be identically sized". All the cells look the same size to me and as far as I
know no merging was done to create the file.... I am attempting to contact
the creator of the file but so far no luck. any ideas? Thank you.

I have at least 4 columbs and an varable amount of rows to deal with.

Trying to sort my data by first columb only I get error message of:
requires the merged cells to be identically sized.

I then formatedd all rows heights to 14 and columd widths to 9.
Received same error message. Any insight please?

Hi. someone sent me what looks like a run of the mill excel file . When I
try to sort it I get a message saying the "operation requires merged cells to
be identically sized". All the cells look the same size to me and as far as I
know no merging was done to create the file.... I am attempting to contact
the creator of the file but so far no luck. any ideas? Thank you.

Hello all. Please see the attached sample. I need to be able to sort the information by the various headings (ie material, width, gauge) but when I try the Sort opertation, it gives me the error that all merged cells must be the same size. This may be due to the fact that I had to "stack" the Qty and Price rows to help with ease of reading.

Can anyone help me be able to sort the info and still keep the layout? Or better yet, is there a better way to lay out this data? I will have a lot more rows and will need to easily sort the info.

Thanks!
wvpersephone13

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)?

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?

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

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

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

Greetings,

I got a spreadsheet from my boss today and put a filter on it. The problem is the filter is completely useless because the "merged cells need to be identically sized." What in the world does that mean? Merged cells? The help button says to "unmerge all the merged cells in the range" or "make each group of merged cells the same size as the largest group." I can find absolutely nothing in the spreadsheet that says what a merged cell is or how to "unmerge" a merged cell.

Thank you for reading this! All I want to do is put a list in alphabetical order. Why did they make it so hard to do that?

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

In my spreadsheet I have a list of names in colA. In this list there are merged cells. The number of cells in each grouping varies. Then in colC I have some other merged cells. There is never merged cells in colC that go across merged cells in ColA. All the rows merged in ColA might not be merged in colC. When I sort this data I want them to be sorted on ColA and the block of rows corresponding to the merged cells to be sorted as a block. Is this even possible? I have tried making the groupings in ColC the same as the groupings in ColA and I still get the message that all merged cells must be the same size.

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

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


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