Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Copy one cell to entire column
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
One of people I work with was playing around and found it by accident. Most
of the tricks I have found have come from this forum. "Tom" wrote: BJ, I have Excel 2003 so this is a tremendous time saving idea! What other jewels do you know or that are lerking out there? Tom "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format cell in column B based on value in the next cell (column c) | Excel Discussion (Misc queries) | |||
up to 7 functions? | Excel Worksheet Functions | |||
In MS Excel, how do I fill in a column with the same cell from se. | Excel Worksheet Functions | |||
Copy a column in worksheet with a character change | Excel Worksheet Functions | |||
Conditional formatting row if cell value in certain column is even | Excel Worksheet Functions |