In this article we’ll learn how to copy formulas in Excel without changing the cell reference or in simple words we can say that how to copy exact formula from one cell to another cell.
There are two ways which you can follow to copy formulas from a range of cells without changing the Absolute reference or Relative reference in Microsoft Excel.
Let’s take an example to copy the formula from a range without changing the cell reference. We have a score card, in which column A contains Student’s name, column B contains scores and column C contains the formula for grades as per the criteria.
Now we need the grade to be copied to another location instead of column C, along with the formulae.
Follow the below given steps to copy the formula to another location: -
You can then revert the column C to its original formulae instead of text, by replacing the “#” to “=” following the above steps.
Incase you want to move the formula to another location, you can follow the below given steps –
To remove the formula from data we can use the “Paste Special” option:-
If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at firstname.lastname@example.org
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.