Copy & paste

  • Thread starter Thread starter Boenerge
  • Start date Start date
B

Boenerge

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
 
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.
 
Many Thanks
Jason

Leah said:
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.
Click to expand...
 
Back
Top