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 SupremeWealthAlliance.net ~ Kumita sa Internet, Kahit Super-BUSY Ka

Get In Touch With Manuel Today
Manuel@Viloria.net



  Previous Entry
  Next Entry


Secondthoughts @ Viloria.com
Manuel Viloria

Viloria.com
About Manuel Viloria
Secondthoughts
Archives
Angelhouser
Contact Us
Privacy Statement
RSS Feed


Google Reader


Copyright © 1996 - 2012 by Viloria.com All Rights Reserved.