QUESTION :
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
ANSWER :
=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.
Yes, use absolute references
$L$15