Results 1 to 4 of 4
  1. drj400m's Avatar
    Posts
    19 Posts
    Global Posts
    56 Global Posts
       #1  
    I have DTG 6.0 and am running with treo 600.
    I have made an excel worksheet and want to sort vertically but keep the horizontal values together. I can do that with Excel on the Mac but when I try it on the treo it states the it will sort the cell but will not sort the cells to the right or left.
    Do I need an update or is it even possible on the treo with DTG??
    Thanks to all that reply.
    Jeff
  2. #2  
    I have DTG 7.003 now so I can't verify this works on 6.0. With DTG 7, select all the rows/columns in the spreadsheet and then do a Sort on the column values. Unlike Excel, you can't select the upper left cell to get the whole spreadsheet - you have to drag the selection across the rest of the spreadsheet.

    Hopefully this will work on DTG 60 for you
  3. drj400m's Avatar
    Posts
    19 Posts
    Global Posts
    56 Global Posts
       #3  
    Apparently in DTG 6.0 you cannot do that. I tried to select the whole spreadsheet and it again states that it cannot sort the columns to the left and right of "sorted" column.
    But thanks for your reply
    Jeff
  4. drj400m's Avatar
    Posts
    19 Posts
    Global Posts
    56 Global Posts
       #4  
    Feel stupid, you select the entire spread sheet then select format then chose sort and it asks you which columns to sort.
    So tomvb2000 your reply was the way to do it.
    Thanks!!!
    Jeff

Posting Permissions