As most of you know, when a formula is copied across or down in a spreadsheet, the columns/rows adjust proportionate to the distance that they are copied e.g. copy a formula from A1 to A2 and the row references in the formula (when relative) will increase by 1.

Anyone have any tips on how to modify this behaviour so that when the formulas are copied the references change by a different amount, other than by merely changing the distance that they are copied?

For example let’s say there’s a spreadsheet with two columns- A and B.

In A1 the formula is **=B1**. If I copy it down one row, is there any way to get it to reference, say B3, rather than B2, without having to copy it down the two rows normally required?

Perhaps using the **row** function or something?

As always, thanks in advance.