Excel has long included the ability to merge adjacent cells into a larger, single cell. This ability has been used by many worksheet designers to give their worksheets a polished, professional look. There is a huge drawback to using merged cells, however:

If you try to sort the cells that contain merged cells in the selected range of cells, and you will get a warning message dialog, it will warn you that “to do this, all the merged cells need to be the same size”. So how to sort the data in selected ra

Sort data with merged cells by unmerging all cells first. You can unmerge all merged cells at first, then go ahead to sort the list. Please do as follows. 1. Select the list with merged cells you need to sort, then click Home > Merge & Center to un