Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Cape Cod
    Posts
    117
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Sorting More Than Three (Excel2000)

    I'm having trouble sorting my spreadsheet. It has columns A to AE. All of the columns are not included in the sort.
    SortBy only gives me columns A to S--Thenby-- the same columns.
    How do I include all the columns?

    Paul B

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Sorting More Than Three (Excel2000)

    Check whether column T is blank. Excel will automatically select a contiguous filled range for sorting. so if T is blank, it'll select a range in columns A through S.
    If you want to force Excel to take columns A through AE into account, select the entire range you want to sort before selecting Data | Sort.

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sorting More Than Three (Excel2000)

    That probably means that column T is empty at least the first cell in column T is empty. Either put something in T1, or select the entire area to be sorted before starting the sort.
    Legare Coleman

  4. #4
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sorting More Than Three (Excel2000)

    The sorting procedure will only sort the data in a continuous area. If there is a gap in the columns (see example below), the columns on the other side of the gap will not be included in the sort. You need to select all column whose data you want to be included in the sort.


    Columns 1 and 2 will sort together or column 4 will sort by itself. They will only sort together if all 4 columns are selected first.

    <table border 1><td>Col1</td><td>Col2</td><td>Col3</td><td>Col4</td><td>a</td><td>1</td><td> </td><td>k</td><td>b</td><td>2</td><td> </td><td>j</td><td>c</td><td>3</td><td> </td><td>i</td><td>d</td><td>4</td><td> </td><td>h</td><td>e</td><td>5</td><td> </td><td>g</td><td>f</td><td>6</td><td> </td><td>f</td><td>g</td><td>7</td><td> </td><td>e</td><td>h</td><td>8</td><td> </td><td>d</td><td>i</td><td>9</td><td> </td><td>c</td><td>j</td><td>10</td><td> </td><td>b</td><td>k</td><td>11</td><td> </td><td>a</td></table>

  5. #5
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Cape Cod
    Posts
    117
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sorting More Than Three (Excel2000)

    You guys are right. Column T was empty.I inserted some data and the sort works ok. Thanks

    Paul B

Posting Permissions

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