# How to 'drag-copy' a formula to the same row and modify (only) the row parameter (and vice versa)?

Hello,

I've got another question. I'm pretty sure someone has asked this before, but I have no idea how to google this problem.

First off, I wanna define what I mean by 'drag-copy': If you select a cell and click on that little square at the bottom right corner of the black rectangle and drag it somewhere, it copies the value/formula of the cell, probably modifying the formula's cell references.

I know the `$`

operator. What I sometimes wanna do, is to copy the formula from one cell to other cells in the same row and I want calc to modify the row parameter automatically (which it doesn't, because it's the same row; calc would only modify the column parameter).

Example: In A1 there is the formula `= A2 + 42`

. Now I want to copy the value to the cells B1, C1, D1 and E1. The result will be for B1 `= B2 + 42`

, for C2 `= C2 + 42`

and so on.

If I have in A1 `= $A2 + 42`

, the results will be like B1 `= $A2 + 42`

.

But what I actually want, is B1 `= $A3 + 42`

, C1 `= $A4 + 42`

and so on.

Is there a way to achieve this? Pressing `CTRL`

or `SHIFT`

while copying doesn't seem to work. I've got the same question if you only want to change the column parameter when copying to the same column, but I assume it has the same solution.

I found a solution only for one situation: If you don't need to modify the cells formulas' after copying.

New example: In A1:A5 are some arbitrary values and I want the same values in A10:E10. Then I can use this formula in A10 `= TRANSPOSE(A1:A5)`

and hit `CTRL + SHIFT + RETURN`

to declare it as an array function. But this works only, if I don't want to - for example - change the formula in C10 after copying.

I am using Kubuntu 10.14 and LibreOffice Calc Version: 4.3.3.2.

Best Regards