Copy & paste
 

Hi,
I am using excel 2007.
I am trying to copy a row of formulas and paste them exactly into other rows.
When I try this the formula is moved down by the number of rows below the
original.
Any ideas of how to paste the formulas exactly so that they look in the same
columns as the original.

The formula I am using
is:=SUMPRODUCT(--(B7:B174=B179),--(E7:E174<""))/D179*100

I only want the B179 & D 179 in the formula to change to reflect the row,
but the rest to stay the same. Hope this makes sense.


Thanks in advance
Jason Alcorn

Copy & paste
 

Put dollar signs in the cell reference. For example $B$4 will set that as a
permanent cell referenced. If you only want the Column to be fixed it would
be $B4, and only a fixed row would be B$4. If you put the cursor in the
middle of the cell reference and hit F4 the $ will come up for you.

"Boenerge" wrote:

Hi,
I am using excel 2007.
I am trying to copy a row of formulas and paste them exactly into other rows.
When I try this the formula is moved down by the number of rows below the
original.
Any ideas of how to paste the formulas exactly so that they look in the same
columns as the original.

The formula I am using
is:=SUMPRODUCT(--(B7:B174=B179),--(E7:E174<""))/D179*100

I only want the B179 & D 179 in the formula to change to reflect the row,
but the rest to stay the same. Hope this makes sense.


Thanks in advance
Jason Alcorn

Copy & paste
 

Many Thanks
Jason

"Leah" wrote:

Put dollar signs in the cell reference. For example $B$4 will set that as a
permanent cell referenced. If you only want the Column to be fixed it would
be $B4, and only a fixed row would be B$4. If you put the cursor in the
middle of the cell reference and hit F4 the $ will come up for you.

"Boenerge" wrote:

Hi,
I am using excel 2007.
I am trying to copy a row of formulas and paste them exactly into other rows.
When I try this the formula is moved down by the number of rows below the
original.
Any ideas of how to paste the formulas exactly so that they look in the same
columns as the original.

The formula I am using
is:=SUMPRODUCT(--(B7:B174=B179),--(E7:E174<""))/D179*100

I only want the B179 & D 179 in the formula to change to reflect the row,
but the rest to stay the same. Hope this makes sense.


Thanks in advance
Jason Alcorn