Sorting cells in a column is easy. But how to sort cells in a row?

Question

Assume school language learning exercise, based on making right order of words in a scrambled sentence.

enter image description here

Then put numbers into the next row, specifying the order the words should be in.
Now select the 4×2 rectangular area, complete with the numbers.

enter image description here

Right click.
Arrange according numbers from low to high.

How? (make influence of arranging by lately added random numbers)

Select all, transpose to new range, sort range for number column, transpose again, copy back. Uff, not very intuitive — nixda, Aug 1, 2013 at 14:36
raystafarian - dont know what is pivot. in my native language excel i have not that word. — Rapier, Aug 1, 2013 at 15:16

Scott - Слава Україні · Accepted Answer · 2013-08-01 15:24:18Z

4

In the “Sort” dialog box, click on “Options” and select “Sort left to right”:

enter image description here

then,

enter image description here

answered Aug 1, 2013 at 15:24

21.7k46 gold badges64 silver badges122 bronze badges

Add a comment |

1 Answer 1