How do I sort a column in Excel with merged cells?
General solution
- Select the entire range you want to sort.
- In the Alignment group on the Home tab, select the Alignment dialog box launcher.
- Select the Alignment tab, and then clear the Merge cells check box.
- Select OK.
How do you sort and Filter in Excel with merged cells?
#8 select Column B, and go to DATA tab, click Filter command under Sort & Filter group. And one filter icon will be added into the first cell of Column B. and you can click the filter icon to filter merged cells.
Can you sort data with merged cells?
Actually, there is no method for you to sort data with merged cells directly. You need to unmerge all merged cells at first and then sort the list.
How to sort a range with no merged cells?
Select cells A1:C3, select Sort & Filter in the Editing group on the Home tab, and then click Custom Sort. In the Sort box, select “Column C” next to Sort By, and then select OK. You should see the error message as documented above. To resolve the issue, do one of the following: Unmerge cells A1:B3 so there are no merged cells in the selection.
How to not merge cells in column C?
Do not merge cells in column C. Select cells A1:C3, select Sort & Filter in the Editing group on the Home tab, and then click Custom Sort. In the Sort box, select “Column C” next to Sort By, and then select OK.
How to sort a range that contains rows and columns?
Each merged cell in the range must occupy the same number of rows and columns as the other merged cells in the range. Select the entire range you want to sort. In the Alignment group on the Home tab, select the Alignment dialog box launcher. Select the Alignment tab, and then clear the Merge cells check box. Select OK.
How to sort a column in excel in ascending order?
1 Select any cell in the column you want to sort. 2 On the Data tab, in the Sort and Filter group, click either A-Z to sort ascending or Z-A to sort descending. Done!