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?