View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
MartinW MartinW is offline
external usenet poster
 
Posts: 860
Default how to copy and paste a row inverted

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 DataSort
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



"Swerd" wrote in message
...
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.