Copy one cell to entire column
- From: Tom <Tom@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 27 Apr 2005 15:51:32 -0700
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
.
- Follow-Ups:
- Re: Copy one cell to entire column
- From: JulieD
- RE: Copy one cell to entire column
- From: bj
- RE: Copy one cell to entire column
- From: Duke Carey
- Re: Copy one cell to entire column
- Prev by Date: Can I use AutoFill or a formula to fill a series of letters?
- Next by Date: RE: Cannot see outline symbols
- Previous by thread: Can I use AutoFill or a formula to fill a series of letters?
- Next by thread: RE: Copy one cell to entire column
- Index(es):
Relevant Pages
|