Assume you want to copy a formula that is in H2 down to H10000
in the name box (above the header in column A), type H2:H10000 and press
enter, then press Ctrl + D

If you have a formula in H2 and all the cells in G2:G10000 are filled then
you can also
move the cursor to the lower right corner in H2 and when it changes from
thick to thin
double click

--


Regards,


Peo Sjoblom

"gfj" wrote in message
...
I need to copy items dow as many as 100,000 rowes is there an easy way
like a/c