Forum Discussion
Copy formula in Rows and Excel without changing the reference manually.
Is there any easy way I can copy IF statement formula to rows and columns both. I have to change the reference for every row to drag it to corresponding columns. I am enclosing the screenshot as an e...
If i understand you correctly, then what you need to look into is the absolute/relative references
https://trumpexcel.com/absolute-relative-mixed-cell-references/
This is the way to determine how formulas adapts to be 'dragged'
https://trumpexcel.com/absolute-relative-mixed-cell-references/
This is the way to determine how formulas adapts to be 'dragged'