Sorting rows into alphabetical order?

[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

[Ken Wright]

Data / Sort / Options / Sort Left to Right

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"tox" <nospam@nospamming.co.com> wrote in message
news:lFzLd.263$497.164@newsfe3-win.ntli.net...
> 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
>
>
>
>

[tox]

"Ken Wright" <ken.wright@NOSPAMntlworld.com> wrote in message
news:#Mu87G$BFHA.4008@tk2msftngp13.phx.gbl...
> Data / Sort / Options / Sort Left to Right
>
> --
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

[Ken Wright]

Do you need all 365 - Are you 7 days a week?

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"tox" <nospam@nospamming.co.com> wrote in message
news:VXzLd.299$9R6.105@newsfe2-win.ntli.net...
>
> "Ken Wright" <ken.wright@NOSPAMntlworld.com> wrote in message
> news:#Mu87G$BFHA.4008@tk2msftngp13.phx.gbl...
> > Data / Sort / Options / Sort Left to Right
> >
> > --
> 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
>
>

[tox]

"Ken Wright" <ken.wright@NOSPAMntlworld.com> wrote in message
news:OHXdIxICFHA.868@TK2MSFTNGP10.phx.gbl...
> Do you need all 365 - Are you 7 days a week?
>
> --
Hi Ken, we're six days a week.

Regards
tox

[Ken Wright]

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

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"tox" <nospam@nospamming.co.com> wrote in message
news:HzSLd.1804$O64.914@newsfe1-win.ntli.net...
>
> "Ken Wright" <ken.wright@NOSPAMntlworld.com> wrote in message
> news:OHXdIxICFHA.868@TK2MSFTNGP10.phx.gbl...
> > Do you need all 365 - Are you 7 days a week?
> >
> > --
> Hi Ken, we're six days a week.
>
> Regards
> tox
>
>

[tox]

"Ken Wright" <ken.wright@NOSPAMntlworld.com> wrote in message
news:e3s9LfKCFHA.520@TK2MSFTNGP09.phx.gbl...
> Afraid you're done and stuck with a vertical layout as even with six days
> you need 312, sorry.
>
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

[Ken Wright]

I'm assuming you meant columns :-)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"tox" <nospam@nospamming.co.com> wrote in message
news:UCTLd.425$Y66.26@newsfe2-win.ntli.net...
>
> "Ken Wright" <ken.wright@NOSPAMntlworld.com> wrote in message
> news:e3s9LfKCFHA.520@TK2MSFTNGP09.phx.gbl...
> > Afraid you're done and stuck with a vertical layout as even with six
days
> > you need 312, sorry.
> >
> 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
>
>

[tox]

"Ken Wright" <ken.wright@NOSPAMntlworld.com> wrote in message
news:uqY3TGMCFHA.3592@TK2MSFTNGP11.phx.gbl...
> I'm assuming you meant columns :-)
>
LOL, yep...

Regards
tox