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
I want to multiply every value by 300, so I put
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?)
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