2 Replies Latest reply: Jan 18, 2013 5:19 PM by Badunit
carlosptorres Level 1 Level 1 (0 points)

Is their a way to will sort columns on the sheet at the same time and independently of the data in

the other columns?

 

Example:

A B C

1 fred john james

2 albert zack chris

3 bill curt mike


Updated:

A B C

1 albert curt chris

2 bill john james

3 fred zack mike

  • 1. Re: Microsoft Excel - Sorting columns independently
    Jerrold Green1 Level 7 Level 7 (28,995 points)

    No. Not singly, nor all at once. If you must do that, stick with Excel or an Office clone. In Numbers it isn't necessary to have unrelated sets in the same table, so there is no need to be able to sort one column independently from another.

     

    Jerry

  • 2. Re: Microsoft Excel - Sorting columns independently
    Badunit Level 6 Level 6 (10,815 points)

    There is a way to do them independently (but not at the same time) but it almost isn't worth it unless you really really have to do this kind of sort. And it may not do it the same as Excel if there are formulas in the column. You have to drag the column out of the table, drop it on an empty place on the page to make a separate table from it, sort it, then put it back where it started.

     

    If you want to give it a try, click on the column letter then click and hold on the column letter and drag down and away. Drop it on an empty place. When you're done sorting, do the same basic drag&drop thing to put it back. A line will appear on the table to show where it will get placed.

     

    By the way, this is a good feature to know about because it makes it really easy to rearrange columns or rows in a table. You can drag and drop a column/row or a set of them from one place to another within the table or you can drag them out and create a separate table from them.