SOLVED
Home

auto fill on only one part of the formula

LinaVal
Occasional Visitor

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 change the formula to pull from a different cell, instead of G5, i need it to pull from E2. That is the only change I want. 

 

How do I update the formula on the entire column without having to manually type a different cost on each cell?

 

Thanks, 

 

LinaVal

1 Reply
Solution

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.

 

2019-09-25_08-26-30.gif

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies