Addy

Enter the formula in A1 then select the namebox and enter A1:A30 and <enter

Now hit CTRL + D to fill down.


Gord Dibben MS Excel MVP

On Thu, 12 Jan 2006 10:02:02 -0800, "Addy"
wrote:

well i need to fill the formulas n series uptill 30 cells but i don't like
dragging so is there an other way

"Peo Sjoblom" wrote:

Select the first cell with the formula, press Ctrl + Shift & down arrow,
will select to the last cell, then press Ctrl + D to fill formula down
That begs the question why would you need 65536 formulas, you realize it
will make the workbook slower and if you don't use more than let's say 1000
rows it's a real waste?


--

Regards,

Peo Sjoblom

"Addy" wrote in message
...
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