Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jul 2001
    Location
    Florida, USA
    Posts
    394
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Sorting rows (Office 2000)

    Hi, I'm trying to sort rows based on the information in column B (which happens to be member's names).
    Columns C thru G are merged into one starting from row 7 on down. When I highlight rows 11 thru 27 by clicking on the row number, and do a Data/Sort based on col B, I always get the error: "This operating requires the merged cells to be identically sized."
    They look identical to me! I've clicked on every cell and they are all merged the same.

    What am I missing here?
    Thanks!
    Louise

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Sorting rows (Office 2000)

    Column B is NOT the same size as a merge of columns C:G
    Add 4 cols to column B and merge it into a "5 column"-column like the "C-G" column and it should work.

    Or unmerge c:g, sort then remerge them.
    Excel has buttons (you can custom add them to your toolbar, they are both in the FORMAT category under commands) that would allow you select C11:G27,
    "unmerge the cells", [builtin button]
    then you can sort,
    then highlight C11:G27 again
    and choose the "Merge Across" [another builtin button]

    You could also write your own macro to do the sorting and remerging.

    Another option is to NOT merge C:G, you could chose "center across selection" instead (format cells - alignment - horizontal)

    Steve

  3. #3
    3 Star Lounger
    Join Date
    Jul 2001
    Location
    Florida, USA
    Posts
    394
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sorting rows (Office 2000)

    Hi Steve,
    Now I understand! <img src=/S/clapping.gif border=0 alt=clapping width=19 height=23>
    I will probably "unmerge" them and use the "center across selection" as you suggested. Didn't know about that one!

    Thanks again!
    Louise

Posting Permissions

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