Microsoft Excel Sorting

Discussion in 'Bing' started by Archit, Nov 26, 2009.

0
  1. #1
    I want to lock the first row of my excel sheet and make something like this which Google Docs provides:

    [​IMG]

    So basically it locks the first row and puts a sorting option under it, I want that. How do we make this in Excel?
     
    Archit, Nov 26, 2009 IP
  2. row_01

    row_01 Member

    Messages:
    78
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    43
    #2
    The sort method in Excel works the same way. Simply select a table with header and press Alt H-S-O to sort from greatest to least.

    You may also be looking to freeze panes. That's alt W-F-F.
     
    row_01, Nov 28, 2009 IP
    Archit likes this.
  3. Archit

    Archit Peon

    Messages:
    79
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #3
    That did it. Thanks a ton! :)
     
    Archit, Nov 29, 2009 IP