Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Jun 2002
    Location
    Durham, North Carolina, USA
    Posts
    140
    Thanks
    5
    Thanked 1 Time in 1 Post

    Sorting a sheet with multiple heading rows (Excel XP)

    Howdy everyone,

    My friend is trying to sort a sheet which has multiple heading rows. Excel's help says to wrap the text to make it look like two rows, but as you'll see in the attachment this is a case where the column headings spread across multiple rows, so wrapping just isn't going to work.

    Anyway around this?

    Thanks in advance.

  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 a sheet with multiple heading rows (Excel XP)

    1) you can explicitly give the range to sort and not include the header rows

    2) Excel will allow 2 header rows, if they appear to be header rows. Fill in all the blanks cells in the 2nd row (with a space, eg) and have them all bold and excel should "guess" that it is a header row. With it blank, it does not seem to be a header row to excel

    Steve

  3. #3
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Vancouver, Br. Columbia, Canada
    Posts
    268
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Sorting a sheet with multiple heading rows (Excel XP)

    If you insert a hidden blank row between the two rows, Excel will guess that only the lower of the two (visible) rows is intended to be the header - you will have to ensure that any descriptions are meaningful using only that row. If this is going to be sorted by a VBA routine then that doesn't matter - but then you can set the sort range directly in any event...

  4. #4
    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 a sheet with multiple heading rows (Excel XP)

    This still requires no blank cells in this row.

    It may be better to insert the hidden blank row underneath the 2 header rows, as excel will more likely assume there is no header row...

    Steve

  5. #5
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sorting a sheet with multiple heading rows (Excel XP)

    Is your friend trying to sort using the menu command or VBA code?
    Legare Coleman

Posting Permissions

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