Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: sorting error message

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    67
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Question: I am trying to sort a worksheet. However, I got an error message"This operation requries the merged cells to be identially sized" when I click the sort button
    I have some merged cells but how could I make them identically sized???
    Thanks in advance

  2. #2
    MrExcel MVP Al Chara's Avatar
    Join Date
    Feb 2002
    Location
    Newark, Delaware
    Posts
    1,701
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Basically it is saying you cannot sort merged and unmerged cells. I do not know of a way around this.
    Best regards,
    Allan Chara
    http://www.mrspreadsheets.com

  3. #3
    MrExcel MVP Jay Petrulis's Avatar
    Join Date
    Mar 2002
    Location
    Chicago, IL USA
    Posts
    2,040
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Allen,

    The only workaround I can think of is to copy your data to another (hidden?) column and sort on that one. Other than that, you will have to unmerge the cells.

    Bye,
    Jay

  4. #4
    Board Regular
    Join Date
    Mar 2002
    Posts
    67
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hello Jay
    Could you explain your answer a little bit more.
    Do you mean copy my entire data to another hidden column or just the data that have merged cells?
    Also what is hidden column?
    Thanks in advance

  5. #5
    MrExcel MVP Jay Petrulis's Avatar
    Join Date
    Mar 2002
    Location
    Chicago, IL USA
    Posts
    2,040
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Allen,

    My thoughts were that you would be able to copy the values to a new column and then sort that. You could then hide the extra column so you wouldn't have to show the duplicate data. That doesn't work, though. Big OOPS! on my part.

    You can still do this with the new data if you only wish to sort that particular new column (the selection is *not* expanded). However, if you wish to sort the entire data range, including the merged columns, it fails.

    You will have to unmerge the cells to sort the entire data set.

    Regards,
    Jay

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •