Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy & paste
I got 2 answers on this but still can't get it to work, one answer was
Transpose and the other was autofill, both don't work the way I want. I want to copy columns of numbers down ward and paste the upwards. copy down Cell 1 = 1 cell 2 = 2 cell 3 = 3 paste so cell 1 = 3 cell 2 = 2 cell 3 = 3 2nd question, Transpose is to turn around up and down to left to right? Thanks Bob |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy & paste
Dave Peterson gave a method of filling from bottom to top but was not copy
and paste as you wish. You cannot copy and paste a vertical range of numbers from down to up. You can sort them or re-enter them per Dave's autofill method or use a helper column with a formula of =INDEX($A$1:$A$10,10-(ROW(A1)-1)) copied down will reverse the 10 items in A1:A10 Yes........Transpose turns a column into a row or vice versa and is not applicable in your case. Gord Dibben MS Excel MVP On Sat, 17 Jan 2009 09:05:01 -0800, Bobby wrote: I got 2 answers on this but still can't get it to work, one answer was Transpose and the other was autofill, both don't work the way I want. I want to copy columns of numbers down ward and paste the upwards. copy down Cell 1 = 1 cell 2 = 2 cell 3 = 3 paste so cell 1 = 3 cell 2 = 2 cell 3 = 3 2nd question, Transpose is to turn around up and down to left to right? Thanks Bob |
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) | |||
Copy, paste without file name referenced after paste | Excel Discussion (Misc queries) | |||
Copy; Paste; Paste Special are disabled | 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) |