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?)