sorting a range with merged cells

Wil Moosa

Well-known Member
Joined
Aug 11, 2002
Messages
893
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?
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
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.
 
Upvote 0
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?
 
Upvote 0
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?

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

Forum statistics

Threads
1,213,513
Messages
6,114,072
Members
448,546
Latest member
KH Consulting

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top