Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 15

Thread: Weired Sorting

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

    Default

    I have several spreadsheets which contain similar data/format. However, when I was sorting the spreadsheet by clicking the sort button. Some of the spreadsheets don't sort the headers, but some include the headers when sort.
    How can I make them sort the same way?
    Is there some kind of hidden format that does this kind of trick?
    Please help

  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

    What format is your data in, numbers, text? What format are the headers in?

  3. #3
    MrExcel MVP Von Pookie's Avatar
    Join Date
    Feb 2002
    Location
    The act or process of locating.
    Posts
    13,686
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Select what you want to sort.
    Go to the menu bar and select Data/Sort.
    You can select whether or not to have a header row.

    Hope this helps!

    Kristy

  4. #4
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Allen

    It is no dout because some of your headings are Bolded and/or some are different formats to the data. Excel will detect bolded first row as headings by default.



    _________________
    Kind Regards
    Dave Hawley
    OzGrid Business Applications
    Microsoft Excel/VBA Training


    [ This Message was edited by: Dave Hawley on 2002-03-15 08:12 ]

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

    Default

    The format of my data have both number/text
    eg.
    Name Weight
    Bob 40
    Lisa 30
    I have changed the headers ,Name/Weight, to bold
    However, they still become part of the data when sort
    The only way I could get the header not included in the sorting is to insert an empty row between data and header. However, it makes the sheet very ugly
    Are there any other solution to this problem?
    Please help
    Thanks in advance

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

    Default

    The format of my data have both number/text
    eg.
    Name Weight
    Bob 40
    Lisa 30
    I have changed the headers ,Name/Weight, to bold
    However, they still become part of the data when sort
    The only way I could get the header not included in the sorting is to insert an empty row between data and header. However, it makes the sheet very ugly
    Are there any other solution to this problem?
    Please help
    Thanks in advance

  7. #7
    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

    I can't duplicate your problem. Did you try Von Pookie's solution? If not, try copying the data and pasting only the values into a new workbook.

    Hope this helps.
    Kind regards, Al.

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

    Default

    I have noticed that the spreadsheet which can separate the headers when sort has assigned the column name
    eg. In Data->Sort, the drop down box shows the headers that I typed in
    However, for the spreadsheets that can't separate the headers when sort the drop down box display Column1, Column2, Column3.... and not the header names
    So, is there a way to let the header names show on the drop down box?
    Thanks in advance

  9. #9
    MrExcel MVP Von Pookie's Avatar
    Join Date
    Feb 2002
    Location
    The act or process of locating.
    Posts
    13,686
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Stupid question, but I'll ask it anyway.

    Do you have both the text and numbers in the same cell? For example, in A1, you have "Bob 40"?

    Kristy

  10. #10
    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

    For the spreadsheets that are having problems, under Data|Sort|"My list has" is "Header Row" clicked?

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
  •