Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Copy and dragging cells
Hi,
Does anybody know how to change the nature of copy and dragging of cells? For example I have data in A1:A50. Then on column B, I want to copy A50:A1 data to B1:B50. If I use formula = A50 on B1 then drag it, it would increment. In this case, I want to decrement. Is there a way to do this? Thank you. Alexandra |
#2
|
|||
|
|||
Hi
in B1 enter =OFFSET($A$50,-(ROW()-1),0) and copy this down -- Regards Frank Kabel Frankfurt, Germany "Alex Jacinto" schrieb im Newsbeitrag ... Hi, Does anybody know how to change the nature of copy and dragging of cells? For example I have data in A1:A50. Then on column B, I want to copy A50:A1 data to B1:B50. If I use formula = A50 on B1 then drag it, it would increment. In this case, I want to decrement. Is there a way to do this? Thank you. Alexandra |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i set up excel to copy from one cell to a given number of . | Excel Discussion (Misc queries) | |||
how to copy formulas to other cells in excell | Setting up and Configuration of Excel |