how to copy and paste a row inverted

[Swerd]

I am using excel 2002. I want copy and paste a row. But I want to paste this
inverted which last cell on the original copy becomes the first in the new
copy.

 

[MartinW]

Hi Swerd,

I'm pretty sure that can't be done in the copy and paste
procedure, but you can flip a row with a *helper* row.

Insert a row beneath the row you want to flip.
Put 1 in the first cell and 2 in the second cell.
Highlight both cells then drag across to the end of your data.

Then higlight both rows and go to Data>Sort
Click Options and select sort left to right and OK
Then select your helper row and check descending, then OK
Delete your helper row and you should be done.

HTH
Martin

 

[RagDyeR]

How about a formula?

Say data A1 to J1.

Enter this *anywhere*, and drag across 10 columns:

=INDEX($A1:$J1,COLUMNS(A:$J))

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

I am using excel 2002. I want copy and paste a row. But I want to paste this
inverted which last cell on the original copy becomes the first in the new
copy.