Sorting rows into alphabetical order?

T

tox

Ok, sorting a column in to alphabetical order is easy, using the a-z button.
How do I do this in a row across the page. I've tried highlighting the row
and using the a-z button, but alas, no joy.

TIA
tox
 
T

tox

Ken Wright said:
Data / Sort / Options / Sort Left to Right

--
Click to expand...
Brilliant, Ken. BTW, I'm writing a holiday and staff attendance chart, with
the dates in horizontal row and the names in the vertical column. Trouble is
there are not enough boxes in the horizontal row to get the 365 days of the
year. I've tried putting the names in the horizontal column and the dates in
the vertical column, however it's difficult to navigate. Any suggestions?

Regards
tox
 
K

Ken Wright

Afraid you're done and stuck with a vertical layout as even with six days
you need 312, sorry.
 
T

tox

Ken Wright said:
Afraid you're done and stuck with a vertical layout as even with six days
you need 312, sorry.
Click to expand...
Cheers anyway. Although I cant for the life of me understand why Excel
doesn't have more rows to accommodate the number of days in a year plus a
few extra.

Regards
tox
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting Colums into alphabetical order 2
changing alphabetical order in excel 5
Sorting stuff into alphabetical order 4
How to Navigate Through Records in Alphabetical Order 2
Open File menu sort alphabetical. 6
Sorting of No.Of Worksheets in a Workbook 1
How to sort names in alphabetical ascending order? 7
Sorting Numbers as Text 3

Top