how to paste the date of the row in the reverse order i.e
11,25,34,70,61,80,90,100 100,90,80,61,70,34,25,11

You could sort it. Select the range and open the Sort dialog. Click the
Options button and pick Sort Left to Right. Then pick Descending as the
sort order.

--
Jim
"Kamal Dalakoti" <Kamal wrote in message
...
| how to paste the date of the row in the reverse order i.e
| 11,25,34,70,61,80,90,100 100,90,80,61,70,34,25,11

Sort across as Jim suggests if data is in ascending order.

If random order enter this in A2 and drag across to H2

=INDEX($A$1:$H$1,8-(COLUMN(A:A)-1))


Gord Dibben MS Excel MVP


On Thu, 25 Sep 2008 03:41:00 -0700, Kamal Dalakoti <Kamal
wrote:

how to paste the date of the row in the reverse order i.e
11,25,34,70,61,80,90,100 100,90,80,61,70,34,25,11