On Friday 24 June 2005 10:38 am, Uwe Brauer wrote:
> Hello
>
> I would like to sort say a certain column alphabetically but I want
> to leave all the rows, invariant, that is if a column gets sorted all
> the existing rows get sorted as well.
>
> Example
>
>
> This 1
> Book 2
> Cesar 3
>
> When I sort the first column alphabetically I would obtain:
>
> Book 2
> Cesar 3
> This 1
>
>
> But I like to have
>
> Book 1
> Cesar 2
> This 3
>
>
> Is this possible, maybe there exists a macro?
>
>
> Uwe Brauer
If I understand you correctly, you want to sort one column and that
is it. The information in the other columns remains in the order it was
in the beginning. If this is the case, click the letter at the top of
the column you want to sort. Data > Sort will bring up a window in
which you decide how you want that column to be sorted. Click OK.
To sort a row or column, it must be highlighted first. If you want
to sort multiple columns or rows at one time, they must all be
highlighted.
Dan
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
