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

Thread: Don't want to sort the header

  1. #1
    Guest

    Default

    Question:
    I am trying to sort a worksheet. However, after I click sort button, the headers of the spreadsheet are also get sorted.
    Is there a way to set the header rows, so they don't get sorted?
    Thanks in advance

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

    Default

    Hi

    Use the Data>Sort path rather than the icon.



  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-12 07:58, Anonymous wrote:
    Question:
    I am trying to sort a worksheet. However, after I click sort button, the headers of the spreadsheet are also get sorted.
    Is there a way to set the header rows, so they don't get sorted?
    Thanks in advance
    Apply a distinguishing font format (e.g., Bold, color) to the header. Excel will then recognize the header as such and you can continue to use the Sort toolbar buttons.

  4. #4
    Guest

    Default

    I formated my headers to Bold and Underline. However, the sort button still sorts the header

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

    Default

    So why not use Data>Sort ?



  6. #6
    Guest

    Default

    Because, I tried it and it messed up my entire worksheet.

  7. #7
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    What version of Excel are you using?

  8. #8
    Guest

    Default

    I am using 2000

  9. #9
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I can't reproduce your problem. What's the nature of the list that you're sorting?

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

    Default

    A step-by-step example would help a lot.


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


    [ This Message was edited by: Dave Hawley on 2002-03-12 10:04 ]

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
  •