Forum Discussion
Solved
auto fill on only one part of the formula
Hi all, I am re-doing an excel sheet and i have a formula that looks like this =(3.05*$G$5) the "3.05" is the cost of the item, which means each row under that has a different cost. I need to ch...
Hello LinaVal,
Select the cells with the formulas, then use Find and Replace (Ctrl + H). Make sure to look in formulas and replace $G$5 with $E$2.
Hello LinaVal,
Select the cells with the formulas, then use Find and Replace (Ctrl + H). Make sure to look in formulas and replace $G$5 with $E$2.