Hi Tom

not sure if i'm missing something here, but if you move your cursor over the
the bottom right hand corner of G2 you should see a +
double click on it and the formula in G2 should be replicated down the
column as far as there is data in column F or H.

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Tom" <Tom@discussions.microsoft.com> wrote in message
news:833184C2-C483-44C9-A6A3-2AAD53A889D9@microsoft.com...
> This seemingly very simply question has me baffled. I have a column of
> data
> that I need to perform an operation, something similar to '=f2-36161'.
> Column F has the data in numeric format. I add a column, say Column G.
> Then
> I put into G2 the '=f2-36161' and then convert this new number to a date
> formatted 'mm/dd/ccyy'. I'd like to replicate (copy/paste) this G2
> calculation and operation down through the entire Column G. [Column G is
> about 15000 rows deep.]
> Is there an easy way to do the copy/paste or replicate without copying G2
> and then copy/paste MANUALLY down the column until I reach the end of the
> data?
> Seems like a simply question but I can't find the 'key'.
> Thanks,
> Tom