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

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