Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Oct 2009
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I am currently working with a spreadsheet consisting of 500 rows and so far 8 columns. The cells contain letters A, I, and W. So far, I have been able to sort the rows by all 8 columns. I have been adding one column a week after starting with 4 columns. After the column 5 sort, I began to receive a message about potential compatibility issues with previous versions of excel. I would like to get to 13 columns in a single sort if I can. My question is there a limit of how many columns can be sorted in excel 2007?

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,434
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    According to Microsoft:

    Excel Specs

    A single sort can have up to 64 levels.

    RG
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  3. #3
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Older Excel versions cannot sort more than 3 columns at the time, hence the warning message. To sort more columns in older versions, you'd start by sorting the table on the least important sort keys and work your way up.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •