2

In Numbers, how is it possible to sort selected columns by a row? In the following example I want to sort the columns B, C and D by using the values in row 1.

example

So far, I have only found the reverse action (which does what it is supposed to) "sort selected rows by column".

1 Answer 1

4

Transpose the sheet (Table->Transpose rows and columns), sort, and then transpose back. However you may lose some of the formatting, like column widths and row heights.

1
  • That is a clever workaround!
    – ben
    Dec 23, 2014 at 11:43

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .