Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Sorting values in a row?

2 views
Skip to first unread message

Salmon Egg

unread,
Jan 27, 2010, 5:30:13 PM1/27/10
to
If I have a row of characters, how do I sort the row so that the
selected cells are in alphabetical order?

Bill

--
An old man would be better off never having been born.

macropod

unread,
Jan 28, 2010, 12:19:32 AM1/28/10
to
Hi Bill,

Data|Sort > Options > Sort left to right.

--
Cheers
macropod
[Microsoft MVP - Word]


"Salmon Egg" <Salm...@sbcglobal.net> wrote in message news:SalmonEgg-943C4...@news60.forteinc.com...

Salmon Egg

unread,
Jan 28, 2010, 1:14:56 AM1/28/10
to
In article <eUOogl9n...@TK2MSFTNGP04.phx.gbl>,
"macropod" <macr...@invalid.invalid> wrote:

> Hi Bill,
>
> Data|Sort > Options > Sort left to right.

I tried it and it worked for one row of cells. I could not figure how to
do it for a rectangular array of cells. I tried recording a macro, but
Excel balked and I could not do it. I could have used an old fashioned
macrosheet but Excel does not seem to support that any more.

0 new messages