Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
Excel and Notepad: how avoid additional inverted commas after copy | Excel Discussion (Misc queries) | |||
Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
Excel cut/Paste Problem: Year changes after data is copy and paste | Excel Discussion (Misc queries) | |||
I cannot paste from one workbook to another. Copy works, paste do. | Excel Discussion (Misc queries) |