Clicking a third time, I get the "Can't sort with merged cell" message. What actually happens on the third click is that the table is returned to the default sort. Show However, it does look like there is a sort bug on strings from my experience. It looks like sorting only applies to the first word in a string When you sort a range in a Microsoft Excel worksheet, Excel does not sort the range. Additionally, you may receive the following error message: This operation requires the merged cells to be identically sized. Cause This issue might occur if you sort a range of cells, and if the following conditions are true:
Workaround To work around this issue, split all the merged cells in the range, or merge all the cells in the range so that the merged cells are the same size. Each merged cell in the range must occupy the same number of rows and columns as the other merged cells in the range. Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support. You may receive an error message when you sort a range that contains merged cells in Excel
In this articleSymptomsWhen you sort a range in a Microsoft Excel worksheet, Excel does not sort the range. Additionally, you may receive the following error message: This operation requires the merged cells to be identically sized. CauseThis issue might occur if you sort a range of cells, and if the following conditions are true:
WorkaroundTo work around this issue, split all the merged cells in the range, or merge all the cells in the range so that the merged cells are the same size. Each merged cell in the range must occupy the same number of rows and columns as the other merged cells in the range. General solution
Note This can alter the layout of the data in the range. Example solution
In the Sort box, select "Column C" next to Sort By, and then select OK. You should see the error message as documented above. |