sorting a range with merged cells

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.

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?

kmjones said:

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?

Click to expand...

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

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