Article ID: 813974 - View products that this article applies to.
For a Microsoft Excel for Macintosh version of this article, see 178966
When you try to 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.
This issue may occur if you sort a range of cells, and if the following conditions are true:
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.
Steps to reproduce the problem
Article ID: 813974 - Last Review: January 30, 2007 - Revision: 7.2
Contact us for more help
Connect with Answer Desk for expert help.