I am looking to fill a formula in specific cell say A2
then I want this formula to be there in the whole column A, i.e. from
A2:A65536
Till now the only way I know is to drag the formula and it autofill the
cells with the formul but if I need to do it all the way uptill cell no 65536
then it takes a lot of time to drag.

Please can ne 1 tell of any other substitute method for doing the same.

I am looking for a similar kind of thing for filling the series where we
just specify the source of the series and till where do we want to extend the
series/ Formula.

Any help would be greatly appreciated.
Thanks in advance