Quick excel question

[silverfoxcc]

Have not used it or years, and unlike riding a bike i have forgotten the following!

Need to get an inch into 1/64th increments
Col A is has 1-64 on rows 1-64

Col B will be 0.015625( 1/64in in decimal)

How do i get row 2-64 to auto fill instead if multiplying manaully 0.015625 by 2,3,4....64

I have put cell C1 with 0.015625 so i can start of in B2 with =A2*C1, B3 will be A3*C1 through to B64 being A64*C1

I can recall putting the cursor on a corner of cell B1 and holding the lh mouse button and holding down a key. and the results appearing. I have tried Caps lock/the arrow up key! and control key without any success. What is missing ?

[maccboy]

You can fill down by dressing the bottom right corner down but you'll need to fix the C1 reference by preceding it with a dollar sign, $C$1

[silverfoxcc]

maccboy

Thanks saved me a couple of hours...lol now to add in the number drill sizes for tspping BA!!