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