Quick short cut for formulas in rows

[ACrossley1]

Hi,

I have a document and I want to automatically do the same formula in the next column in the same row.

So basically, if the formula = A$2, I want the next square in the same row to = B$2 and so on for 40 more squares.

If I wanted to do this for a column, I would just click the bottom right hand side of the square and it would automatically move the formulas down the column.

Is there a short cut for the rows as well, instead of the time consuming method of dragging it along?

Thanks.

[AlKey]

Here the process:

Enter any character, letter or number in cell AN2
Click con the cell with your formula in B2
Press and Hold Ctrl+Shift and hit Right Arrow on you keyboard
Press F2 on your keyboard
Press Ctrl key and hit Enter

[ACrossley1]

I cant get it to work, it doesnt seem to fill in the gap?

[AlKey]

I cant get it to work, it doesnt seem to fill in the gap?

If it didn't work, it means you didn't follow instructions as described.