Changing the position of rows

[maysam]

How can I change the position of rows in my worksheet? For example
want to move the rows which have negative values in on of their cells
to the top of the sheet

 

[Kieran]

Maysam,

If you select all of the data, you may be able to sort it (data> sort
and obtain the order you need.

Normally excel's sor is quite robust, however pleqase save your dat
first - just in case

 

[maysam]

Thanks for response, but some thing:
It dosn't necessarily mean sorting, for example in a column, I may hav
values in range of -1000 to 1000, and I may want to bring the 0 value
to the top of the rows which is not kind of sorting, is it

 

[Kieran]

maysam,

A couple of quick thoughts then

1. Filter the data - autofilter may be waht you need. Advanced filte
is a little harder to setup.
2. Create another column that contains the absolute value of the data
Then sort on the new column.

HI

 

[Tom Ogilvy]

You a dummy column next to your data. Put in a formula that produces a
ranking that will produce the required results. Then sort the data using
this column as the key.