coping of cell using dragging the cell downward or rightward

V

Vimlesh

If one cell e.g. A1contains formula =Q12 and one drag cell A1 downward, the
lower copied cell will contain formula =Q13, =Q14, =Q15......and so on. But
can we have the copied formula in this fashion:=R12, =S12, =T12......and so
on while dragging it downwards only.

And vise versa dragging the cell to right should contain =Q13, =Q14,
=Q15......and so on instead of :=R12, =S12, =T12......and so on.
THX
 
J

Jim Cone

In Cell A1...
=OFFSET($Q$12,COLUMN()-1,ROW()-1)
--
Jim Cone
Portland, Oregon USA
Excel add-ins: http://www.mediafire.com/PrimitiveSoftware





"Vimlesh" <[email protected]>
wrote in message
If one cell e.g. A1contains formula =Q12 and one drag cell A1 downward, the
lower copied cell will contain formula =Q13, =Q14, =Q15......and so on. But
can we have the copied formula in this fashion:=R12, =S12, =T12......and so
on while dragging it downwards only.

And vise versa dragging the cell to right should contain =Q13, =Q14,
=Q15......and so on instead of :=R12, =S12, =T12......and so on.
THX
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top