Operation requires the merged cells to be identically sized

Discussion in 'Microsoft Excel Crashes' started by Guarumal, Apr 18, 2008.

  1. Guarumal

    Guarumal Guest

    I get this error message when I try to sort an Excel file on Office 2007.
    "Operation requires the merged cells to be identically sized. The cell range
    that you attempted to sort or remove duplicates from includes merged cells.
    However not all cells in the range are merged to the same size" Can someone
    tells me how to solve this problem.
     
    Guarumal, Apr 18, 2008
    #1
    1. Advertisements

  2. The only way I've been able to do it is to unmerge the cells.
    --
    HTH,
    Barb Reinhardt



    "Guarumal" wrote:

    > I get this error message when I try to sort an Excel file on Office 2007.
    > "Operation requires the merged cells to be identically sized. The cell range
    > that you attempted to sort or remove duplicates from includes merged cells.
    > However not all cells in the range are merged to the same size" Can someone
    > tells me how to solve this problem.
     
    Barb Reinhardt, Apr 20, 2008
    #2
    1. Advertisements

  3. Guarumal

    Guarumal Guest

    Hi Barb,

    How you do that?

    Guarumal

    "Barb Reinhardt" wrote:

    > The only way I've been able to do it is to unmerge the cells.
    > --
    > HTH,
    > Barb Reinhardt
    >
    >
    >
    > "Guarumal" wrote:
    >
    > > I get this error message when I try to sort an Excel file on Office 2007.
    > > "Operation requires the merged cells to be identically sized. The cell range
    > > that you attempted to sort or remove duplicates from includes merged cells.
    > > However not all cells in the range are merged to the same size" Can someone
    > > tells me how to solve this problem.
     
    Guarumal, Apr 22, 2008
    #3
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Guest

    How so you make merged cells identical?

    Guest, Jan 13, 2005, in forum: Microsoft Excel Crashes
    Replies:
    0
    Views:
    671
    Guest
    Jan 13, 2005
  2. Guest
    Replies:
    0
    Views:
    332
    Guest
    Jan 21, 2005
  3. Guest
    Replies:
    1
    Views:
    559
    Nick Hodge
    Mar 16, 2005
  4. Guest
    Replies:
    0
    Views:
    471
    Guest
    Aug 28, 2005
  5. Guest
    Replies:
    2
    Views:
    235
    Guest
    Oct 29, 2005
  6. Guest
    Replies:
    0
    Views:
    260
    Guest
    May 31, 2006
  7. Excel 97 crashes if row 2841 has merged cells.

    , Dec 30, 2007, in forum: Microsoft Excel Crashes
    Replies:
    1
    Views:
    403
Loading...