Originally Posted by

**SilenTScopE**
Sorry, instead of C5 to C15, I meant from C5 to G15. So yes, it works if I do it from C5 to C15.

So let's say Cell A1 has a value of 2. A2=3, A3=4, A4=5, A5=6

Now in cell C5, I put the formula "=A1" and I get a value of 2. That's great.

Now I drag the "fill handle" of cell C5 up to cell G5, and what I would want is that cell D5 gets the value of cell A2, E5=A3, F5=A4 and G5=A5. This does not happen. Instead, E5 gets the formula "=B1" etc.

So it seems to only work when you are doing it parallel. If I want to do this perpendicularly (from a column to a row) it does not work. That's what I meant. Is there a way around this?

## Like this thread? Share it with others