bj

Either adjacent column left or right will do the trick.


Gord Dibben Excel MVP

On Wed, 27 Apr 2005 15:23:32 -0700, "bj" wrote:

In some versions of excel. if the column to the left of a cell is fully
populated and you double click on the little black square on the lower right
corner of the highlighted cell. it will copy that cell down to the lowest
filled cell on the left side column

"Tom" wrote:

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