ps. I should have noted, as David has, that the actual sort order could be
very different over many different rows depending on the nature of the data,
in which case sorting would be required on a row by row basis or with a macro
as Gord suggests.

A

"Anthony D" wrote:

Hi Steve,

The sort function will sort the full data range selected (e.g. in ascending
order) even when only one row (e.g. the first in the range, or any in the
range) or column are specified as "Sort by".

The extra options - the two additional sort criteria Then by - are provided
in case multiple sort criteria are required within the data (e.g. by name
then by telephone number).

Hope that is helpful. Imho, the dialog box with the sort function should
explain this.

Anthony


"Steve F" wrote:


I want to sort multiple rows, but seem to only be able to do one at a
time. I know that to sort multiple columns, I can highlight as many
columns as I want and then select A to Z on the Toolbar. But this
doesn't seem to be the case for sorting rows. In terms of sorting rows,
the only thing I can seem to do is to go into
Data--Sort--Options--Select Left to Right. I can then sort a single
row, and from this window it looks like I may--although I haven't
figured out how to get it to work--be able to sort three rows, but I
cannot tell how I might be able to sort more than three rows. For
instance, suppose I have the following data

3, 2, 1
6, 5, 4
98, 97, 96
33, 32, 21

I want to be able to select all of these rows and quickly sort them as
follows:

1, 2, 3
4, 5, 6
96, 97, 98
21, 32, 33

Thank you




--
Steve F