5

For example, I have one table with values:

14.10%    
1.60%   
2.80%

and I have a cell with value I want to multiply each table row by, eg L15=300

I want to multiply every value by 300, so I put

=A1*L15
=A2*L15

and then drag it down but unfortunately the L15 is incrementing as well:

=A3*L17
=A4*L18 
etc.

Is there any way in excel to auto increment only first part of the equation (all A cells?)

Thank you

1
  • That's it! Thank you so much guys! This was bugging me a long time
    – Flamd453
    Dec 13 '15 at 9:59
15
=A1*$L$15

The dollar sign specifies an absolute (fixed) reference. Without the dollar sign, you'll get a relative reference by default, which is what you're seeing when you autofill.

More info here.

3

Yes, use absolute references

$L$15

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.