Sort Horizontally

W

Woody13

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 . .
...
 
C

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
 
G

Gord Dibben

Woody

Select all rows to sort.

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

Gord Dibben Excel MVP
 
Top