Copping Formula

Occasional Visitor


I have a formula with reference say A1. I want to copy this formula to next right cell with reference D1 and to next G1 and so on, How can I do this?

4 Replies

@Aj_2653 That could be something like:


assuming the first formula is in column A of a sheet. If that's not the case you need to adjust the -1 with the column number where the first formula is entered.




It depends on which formula and where it is located. Assuming in H3 you have =A1+1, you may change it on

=INDEX(1:1, 1, 3*(COLUMN()-COLUMN($H$1))+1,1)+1

and drag to the right

@Sergei Baklan 

I wonder how long it will be before the answer is


Maybe forever, perhaps 'drag' to the right will always be a requirement?

@Peter Bartholomew , that's forever. The only LAMBDA option will be suggested more often among others.