Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.

Excel 'sort' Question.

  • 21-08-2003 09:58AM
    #1
    Pigman II
    Closed Accounts Posts: 10,921 ✭✭✭✭


    Why is it in Excel that when I go to do a sort (Data > Sort > Sort By) it will usually sort by the cell title eg 'Column A' , 'Column B', 'Column C' etc but then on other occasions it will only sort by the actual content of the cells in the first row of the list eg 'apples', 'bananas' , 'cherries' etc.

    I find this problem very irritating as when it occurs it means that the first row in a particular sort selection never gets moved to the correct new position.

    Can some explain why this is happening and how I can get it to stop for good? Thanks!


Comments

  • #2
    dod
    Closed Accounts Posts: 801 ✭✭✭dod


    When you click Data>Sort>Sort by, at the bottom of the Sort dialog box, there is an option- My list has a header row, or no header row. If you tell it there is a header it will use the first row as a column header. If you tell it there is no header, it will treat the first row as part of the data to be sorted


  • #3
    Pigman II
    Closed Accounts Posts: 10,921 ✭✭✭✭Pigman II


    Yep, that's what was causing it. Thanks for that one!


Advertisement