Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    May 2001
    Location
    Berkeley, California, USA
    Posts
    214
    Thanks
    0
    Thanked 0 Times in 0 Posts

    sort includes header row (97 SR2)

    I am sorting a Data base. No matter what I do it sorts the header row.
    I have tried turning the radio button for header row on and off.
    I have tried selecting only A2 through end. It still sorts the header rown which is in A1:P1
    It only started doing this an hour ago. I have sorted it dozens of times over the last few weeks.

  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: sort includes header row (97 SR2)

    Does it do it with other spreadsheets or only this particular one?
    If you toggle between header row/no header row in the sort dialog box, does it deselect and select the header row in the entire range?
    If you sort with the header row NOT selected does it STILL sort the header row?

    Steve

  3. #3
    3 Star Lounger
    Join Date
    May 2001
    Location
    Berkeley, California, USA
    Posts
    214
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: sort includes header row (97 SR2)

    I figured it out. Somhow the outline had changed. I deleted the outline and it sorted proprerly.

Posting Permissions

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