Cells in rows

[kmb0702]

I am trying to copy a row of cells so that the information in each cell will
change by 4 whereas the default seems to be 3. (eg. A1 copys to become A4)

[Bas]

You can try this:

1. Enter the first number in cell A1 and the second in A2
2. Select both of them.
3. Put your mousepointer right under A2 (you're pointer becomes a black
cross)
4. Pull them down by keeping your mouse button down.
5. Starting in cell B2 you enter ="address original row cell"&$A1
6. Put your mousepointer right under B2 (you're pointer becomes a black
cross)
4. Pull them to the right by keeping your mouse button down.
etc.
etc.
Eventually 'Copy' > 'Paste, special, values' all rows to make the
content static.

Hope this helps!

- Bas


kmb0702 wrote:
> I am trying to copy a row of cells so that the information in each cell will
> change by 4 whereas the default seems to be 3. (eg. A1 copys to become A4)