I don't believe you can sort both in one operation. Select your cells, then
Data|Sort and select options. You can then choose "Sort left to right"
instead of "Sort top to bottom". Select ascending or descending depending on
the order you want. Then Sort it again going top to bottom (normal).
"retman" wrote:
Hello,
Below you can find an example of my worksheet:
DC 00 03 20
FE 06 55 20
BD 09 29 40
CT 08 41 70
GT 09 92 80
In this example, you see the sort as I want it (right-to-left and
top-to-bottom). But how can I let Excel do this sort? Now I'm first sorting
all the numbers by hand.
|