how to copy and paste a row inverted
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. |
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. |
how to copy and paste a row inverted
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! ================================================== === "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. |
All times are GMT +1. The time now is 08:21 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com