In Excel, suppose I have a row with, say, 26 formulas horizontally from `A1`

to `Z1`

, and then I move down to cell `A2`

and type a formula. Now I want to fill that formula to the right, through cell `Z2`

. The issue is that if I just use `Ctrl`+`R`, it will fill this formula to the edge of the worksheet. Normally I get around this by going to cell `A1`

, then `Ctrl`+`→ (right arrow)` to the end of the row (cell `Z1`

), then drop down one row to cell `Z2`

, put something (e.g., a `1`

) into that field, then `Ctrl`+`← (left arrow)` to select cell `A2`

, and then finally I do `Ctrl`+`R`, which will fill my formula only through cell `Z2`

.

Is there a much easier way to do this?