If your data values are in ascending order, then Data/ Sort/ Descending
If not in order, add a helper column with ascending values, & sort by that
descending.
--
David Biddulph

"sonicscooter" wrote in message
...
Hi,im new to Excel,so could do with some help,if i have a column,say
A:A200
is it posible to flip the contents of the cells,so that if A1=1 then A2=2
down to A200=200 the result would be that A1 would have the contents of
A200
or A1=200 then A2=199 and so on?

Help apprieciated,thanks.