Data in the range A1:A7.

Enter this formula in B1 and copy down to B7:

=INDEX(A$1:A$7,ROWS(A1:A$7))

If you want to, after you get the data reversed you can convert the formulas
to constants then get rid of the original data.

--
Biff
Microsoft Excel MVP


"Denish D" wrote in message
...
I have values in a column like:

546
3242
54
5645
257
245
1565


i Want to make them in reverse order as :

1565
245
257
5645
54
3242
546

Can any one help me...