Simple formula question

  • Thread starter Thread starter jvioral
  • Start date Start date
J

jvioral

Simple question...

I have two sheets of data. I am taking (A2 * B2) * M3 (on anothe
sheet)

next should be (A3 * B3) * M3 but I copy and it changes M3 to M4

my issue is how do I copy this formula to other cells while keeping th
M3 value from changing
 
The answer is called 'Absolute Reference'.
Select the cell with the first instance of your formula.
In the formula bar select the M3 reference and hit the F4 on the keyboard.
This will place $ signs in front of the M and the 3.
Now when you copy right left up or down the M3 will remain as the cell
reference in ALL copied formulas.

Type 'Absolute Reference' (without quotes) into Help for a complete
explanation.

Dave French
MOS Master Instructor Office XP
 
Back
Top