Excel de formul yazimi

Yeni Mac Office'de formulun ucunda cift tiklamak ise yaramiyor utun sutuna ayni formulu uygulamam icin. Asagidaki ilk oneri super.

1 - Enter A10000 in the Name box and hit enter to select A10000.
2 - Scroll up to A1
3 - Hold the shift key while clicking A1 to select A1:A10000.
4 - Type your formula into the formula bar
5 - Hold the Ctrl key and hit enter.

Or,

Enter the formula in A1 and drag it down to A10000.

Or use this code:

Sub FormulaTenK()
Range("A1:A10000").Formula = "=B1*6"
End Sub