Lucky for us in this case the INDIRECT() function is an easy solution!Don’t forget to check out our PDF to Excel Converter.In most cases when you add a row or column you would want the formula to reference the original (now moved) cell, but there are some cases you don’t want the cell reference to change even when inserting a row or a column.This article shows how to work around this Excel behavior so you can force it to reference the exact cell you choose.Our solution is to use a little-known Excel function called INDIRECT.
Go to the next line and write out the formula for that line by hand. So to make the H5 absolute you need to put in the dollar signs.
Remember that the dollar sign goes before the letter and before the number.
The term H$ is incorrect and will result in an error.
The following sheet allows Pat Wilson to track her car mileage for work trips.
Pat enters her monthly mileage rate on the first row within the Total Amount column.