sorting a range with merged cells

[Wil Moosa]

I try to sort a range of cells. Unfortunately a few columns are merged cells. When I try to sort the rows in alphabetical order I get an error message saying "When sorting the range all merged cells need to be of the same size.

Within the range all the merged cells áre of the same width. some of the cells outside the range aren't but that can not cause the problem... can it?

I do not fully understand what the problem is here and is there a way to overcome this?

 

[onlyadrafter]

Hello,

Instead of using the MERGED CELL option, use FORMAT --> CELLS --> ALIGNMENT --> and in the Horizontal select CENTRE ACROSS SELECTION.
I know this is a long work round to the problem but I can't find another way of doing it, I have had to do this on several occasions.

e.g. MERGE CELLS A1:C1

What I think the program is doing is taking the MERGED CELL as one cell, if you go into it it will say A1, if you scroll right it will go into D1.
However, using the CENTRE ACROSS SELECTION if you go to cell A1 and scroll right you will be in B1.

 

[kmjones]

I tried that. It didnt center it like a merged cell. It is centered in the one cell. But not like vertically. My cells are like 5 rows merged. Also, if I take out the merged cells, how would you sort that column but keep the rest of the information in the columns next to it to sort with it?

 

[Mark W.]

I tried that. It didnt center it like a merged cell. It is centered in the one cell. But not like vertically. My cells are like 5 rows merged. Also, if I take out the merged cells, how would you sort that column but keep the rest of the information in the columns next to it to sort with it?

First, select the entier range that you'd like to sort.

 

[Tom Urtis]

Hi Mark et. al. - - FYI this follow-up question from kmjones is a duplicate of this:
http://www.mrexcel.com/board2/viewtopic.php?t=151946