Replicate functions in a row for other rows.
 

I have a sheet with 1 item per row. i've created several functions in various
cells to calculate amounts based on inputs from cells only in this row. I
want to make all rows following to have the same functions to calculate the
amounts for it's row. Is there a way to replicate or copy all functions in a
row to the next rows but change the row from 1 to 2,3,4,5,6,7, etc?

Replicate functions in a row for other rows.
 

Tom

Just drag/copy the formulas down the column to increment the row number or
across columns to increment the column letter.

i.e. =A1 dragged down becomes =A2, =A3, =A4 etc.

ToolsOptionsEdit "allow cell drag and drop" must be enabled(checkmarked)

For more on cell referencing see help on Absolute and Relative referencing


Gord Dibben MS Excel MVP



On Fri, 6 Apr 2007 09:48:03 -0700, Tom Doggett <Tom
wrote:

I have a sheet with 1 item per row. i've created several functions in various
cells to calculate amounts based on inputs from cells only in this row. I
want to make all rows following to have the same functions to calculate the
amounts for it's row. Is there a way to replicate or copy all functions in a
row to the next rows but change the row from 1 to 2,3,4,5,6,7, etc?

Replicate functions in a row for other rows.
 

WOW, I was WAY over complicating what I needed to do. Thanks!!!!!!

"Gord Dibben" wrote:

Tom

Just drag/copy the formulas down the column to increment the row number or
across columns to increment the column letter.

i.e. =A1 dragged down becomes =A2, =A3, =A4 etc.

ToolsOptionsEdit "allow cell drag and drop" must be enabled(checkmarked)

For more on cell referencing see help on Absolute and Relative referencing


Gord Dibben MS Excel MVP



On Fri, 6 Apr 2007 09:48:03 -0700, Tom Doggett <Tom
wrote:

I have a sheet with 1 item per row. i've created several functions in various
cells to calculate amounts based on inputs from cells only in this row. I
want to make all rows following to have the same functions to calculate the
amounts for it's row. Is there a way to replicate or copy all functions in a
row to the next rows but change the row from 1 to 2,3,4,5,6,7, etc?