Forum Discussion
Excel Automatic Formula
Hello! Question : Is anyone here know how to automatically copy a formula in excel from one cells to different cells ? Non-Adjacent cells. I want automatically copy the formula from the Master. I ...
Hi,
I want to remove the process of using the CTRL shift down.
1. I want the remaining cells downward to automatically copy the formulas on the 1st cell. Every time I change the formula or the conditioning like lookup etc. I want it to apply automatically to the rest.
Now : the formula is 1+1
Then after sometime I will change it to 1-1 or with vlookup, hlookup, etc.
Once I change the formula in Row D3, I want the remaining cells downward to update automatically without using the CTRL Shift Down Arrow. I want to skip that part. If there's a way to do that ?
I want to remove the process of using the CTRL shift down.
1. I want the remaining cells downward to automatically copy the formulas on the 1st cell. Every time I change the formula or the conditioning like lookup etc. I want it to apply automatically to the rest.
Now : the formula is 1+1
Then after sometime I will change it to 1-1 or with vlookup, hlookup, etc.
Once I change the formula in Row D3, I want the remaining cells downward to update automatically without using the CTRL Shift Down Arrow. I want to skip that part. If there's a way to do that ?
