Sort by rows?

[loscherland]

Can you sort information in excel by rows?

i.e. instead of sorting a column in alphabetical order, can you sort i
for accross rows in alphabetical orde

 

[Frank Kabel]

Hi
try the following:
- choose your range
- goto 'data - sort - Options'
- choose: 'sort by columns'

 

[JulieD]

Hi

yes

Data / Sort - click on Options button, choose Sort Left to Right

Cheers
JulieD

 

[Gord Dibben]

You can sort across a row.

Unfortunately can be done only one row at a time.

Select one row then Data>Sort>Options. Check "left to right".

Gord Dibben Excel MVP

 

[RagDyeR]

My XL2k sorts as many rows as I select Gord,
All at the same time, just the same way it does columns.
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

"Gord Dibben" <gorddibbATshawDOTca> wrote in message
You can sort across a row.

Unfortunately can be done only one row at a time.

Select one row then Data>Sort>Options. Check "left to right".

Gord Dibben Excel MVP

 

[Gord Dibben]

RD

You are correct.

Tested with a dozen rows, sort by Row 1 and all rows sorted left to right.

XL2002

Gord