Auto (drag)incrementing only one cell value in Excel

Posted on


For example, I have one table with values:


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


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


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

Thank you



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


Leave a Reply

Your email address will not be published. Required fields are marked *