Sort horizontally

  • Thread starter Thread starter 0-0 Wai Wai ^-^
  • Start date Start date
0

0-0 Wai Wai ^-^

Hi.
Normally when we do a sort, it is sorted vertically (ie straight down)
How about if I wish to sort a list of data horizontally?

Eg:
I have the following data in Row 1:
number -- 13 -- 23 -- 9 -- 45

I do a horizontal sort, so the data in Row 1 becomes:
number -- 9 -- 13 -- 23 -- 45

How to do?
 
Hi

Select your range

Try ...

Data | Sort | Options | Left To Right

kk


Hi.
Normally when we do a sort, it is sorted vertically (ie straight down)
How about if I wish to sort a list of data horizontally?

Eg:
I have the following data in Row 1:
number -- 13 -- 23 -- 9 -- 45

I do a horizontal sort, so the data in Row 1 becomes:
number -- 9 -- 13 -- 23 -- 45

How to do?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

fill horizontally 1
Transposing 0
Mailing address block: sorting 1 row to columns 1
Why the #DIV/0 error??? 1
Multiple colums into a single cell 8
count a pair of numbers in row in a table 1
Locate text in range (multiple occurrences) and report other cell insame column? 10
How to convert vertically address list to horizontal 2

Back
Top