Data/Sort ..... Horizontally

thunderfoot

thunderfoot

Board Regular
Joined
May 28, 2004
Messages
229
Is there a way to sort horizontally, i.e. descending from left to right?
 

Some videos you may like

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).
Oaktree

Oaktree

MrExcel MVP
Joined
Jun 20, 2002
Messages
7,984
Just change the orientation in data --> sort --> options to "Sort left to right"
 
P

PATSYS

Well-known Member
Joined
Mar 12, 2006
Messages
1,749
Is there a way to sort horizontally, i.e. descending from left to right?
Click to expand...

Yes, on Data - Sort - Options - Left to right (orientation).
 
You must log in or register to reply here.

Similar threads

dkubiak
  • Question
Dynamic Horizontal Axis Labels on Chart
Replies
2
Views
72
McGuilliam
M
R
  • Question
VLOOKUP across two sheets, first sheet has data vertically, second horizontally
Replies
9
Views
187
Fluff
Fluff
F
  • Question
Pivot Table Sort Numbers Across
Replies
0
Views
30
F4TMAN
F
J
  • Solved
copy different Horizontal data to vertical
Replies
4
Views
92
johnny52
J
I
  • Question
Excel Automation From Horizontal to Vertical
Replies
3
Views
56
sandy666
sandy666

Watch MrExcel Video

Learn Excel - "Hide Blank Rows Without a Macro" - Podcast #1736

Forum statistics

Threads
1,113,795
Messages
5,544,337
Members
410,603
Latest member
rseckler

Share this page

Top