Sorting problem
Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Sorting problem

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    24
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I have worksheets where the first two rows are the header rows. For most worksheets I just click one of the header rows and click the Sort Ascending button. But for some worksheets sorting does not work where the sorted data is shifted to very top and the header rows are at the bottom. I tried also using the Data – Sort function on the menu bar and selected “Header row” and first heading row is missing. How can solve this problem?

  2. #2
    MrExcel MVP lenze's Avatar
    Join Date
    Feb 2002
    Location
    Helena, MT
    Posts
    13,690
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    I think you will find the sorts will work better if you limit your header rows to one row. If you need to display more than one line in a cell, use Alt+Enter to force a line break in the cell. Make sure you've choosen the wrap text option.

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
  •  

 

 
DMCA.com