Sort Horizontally

[Guest]

Is there a way to sort horizontally? I have data arraged by date with the
most recent dates starting in Col. A and I want to rearrage it so the past
dates start in Colume A and each subsequent date is after in Col. B, C, D . .
...

 

[Chip Pearson]

From the Data menu, choose Sort. Then click the Options button
and choose "Sort left to right" instead of "Sort top to bottom".


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Gord Dibben]

Woody

Select all rows to sort.

Data>Sort>Options button>Sort left to right>OK>Descending

Gord Dibben Excel MVP