Sorting only a set of Rows

[sirdad1]

How does one cause Excel to Sort only a range of Rows (vs the whole column)?
e.g. Rows 15-30 Only
Column D has alpha names
Column E has numeric values

I wish to Sort on Column E (numeric) But only for Rows 15-30.

Thanks

 

[PaddyD]

welcome to the board.

simply selecting the area you want to sort, then sorting, should do it.

paddy

 

[sirdad1]

Thanks - but that doesn't do it under the conditions I have
In a blank sheet with direct values in the cells that works
But - I have references in my cells and I wonder if its sorting on them rather than the actual values
e.g. column W has Team Names -- X has Wins
Row 5 =S6 (value Tigers) =U6 (value 6)
Row 6 =S7 (value Reds ) =U7 (value
Row 7 =S11(value Blues) =U11(value 2)

After I select both columns and all Rows I Sort by column X - but after the sort its all mixed up and there are even values for the missing references (e.g. S8, U8 show up)
This message was edited by sirdad1 on 2002-08-30 05:37
This message was edited by sirdad1 on 2002-08-30 08:33
This message was edited by sirdad1 on 2002-08-30 08:34