You are currently offline, waiting for your internet to reconnect

You may receive an error message when you sort a range that contains merged cells in Excel

Support for Office 2003 has ended

Microsoft ended support for Office 2003 on April 8, 2014. This change has affected your software updates and security options. Learn what this means for you and how to stay protected.

For a Microsoft Excel for Macintosh version of this article, see 178966.
SYMPTOMS
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.
CAUSE
This issue may occur if you sort a range of cells, and if the following conditions are true:
  • You previously merged some cells, but not all cells in the sort range.
  • You previously merged all cells in the sort range and the cells are not all the same size.
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.

Steps to reproduce the problem

  1. In a worksheet, type the following data:
     A1:     B1:  Name      C1: Value   A2:     B2:  Sue       C2: 1   A3:     B3:  Tom       C3: 2
  2. Merge cells A1 and B1, A2 and B2, and A3 and B3. To do this, follow these steps:
    1. Select each pair of cells.
    2. On the Format menu, click Cells.

      Note In Microsoft Office Excel 2007, click the Alignment dialog box launcher in the Alignment group on the Home tab.
    3. Click the Alignment tab, and then click to select the Merge cells check box.
    4. Click OK.

      Do not merge cells in column C.
  3. Select cells A1:C3, click Sort on the Data menu, and then click OK.

    Note In Excel 2007, click Sort & Filter in the Editing group on the Home tab, and then click Custom Sort.
  4. In the Sort box, click OK.
merge prb XL2003 OfficeErrorMessages 10035 XL2007
Properties

Article ID: 813974 - Last Review: 01/30/2007 22:21:12 - Revision: 7.2

Microsoft Office Excel 2007, Microsoft Office Excel 2003, Microsoft Excel 2002 Standard Edition, Microsoft Excel 2000 Standard Edition, Microsoft Excel 97 Standard Edition

  • kbexpertisebeginner kbfaq kberrmsg kbprb KB813974
Feedback
.com/c.gif?DI=4050&did=1&t=">