How To Sort Excel Cells From Left To Right

Someone asked: "How do I sort cells from left to right in Excel?" Normally, our spreadsheet data is arranged under one column, and we sort from top to bottom. But what if the data is on one row (i.e., A1, B1, C1, D1)?

[an error occurred while processing this directive]

I tried look for the solution in the Excel menu, but didn't find any. Maybe you can first arrange your left-to-right data under one column using the Excel Transpose command, sort that column of data, then re-transpose the sorted column back into a single row of data.

UPDATE: Thank you, Jaimie, for sending in the solution --

Click a cell in the list you want to sort.
On the Data menu, click Sort.
Click Options.
Under Orientation, click Sort left to right, and then click OK.
In the Sort by and Then by boxes, click the rows you want to sort.

[ First posted on 04/13/2004 by Manuel Viloria ]

Do you LIKE this page? Please let us know, and we will publish more of the content that YOU want. Salamat po!

Panuorin Mo Ito...

Visit ~ Kumita sa Internet, Kahit Super-BUSY Ka

Get In Touch With Manuel Today

  Previous Entry
  Next Entry

Secondthoughts @
Manuel Viloria
About Manuel Viloria
Contact Us
Privacy Statement
RSS Feed

Google Reader

Copyright © 1996 - 2012 by All Rights Reserved.