Copying Formulas While Keeping Their Relative and Absolute References
Copying Formulas While Keeping Their Relative and Absolute References
Here’s how you can copy a set of formulas and paste them elsewhere, while keeping the original formulas unaffected and keeping the relative and absolute references unchanged.
Before the copy and paste.
After the copy and paste. Notice the same formula in cell G2 as in cell B7.
Select the range and press Ctrl+H to show the Find and Replace dialog box.
In the Find what field, enter the
In the Replace with field enter some unused character, for example the
= character.In the Replace with field enter some unused character, for example the
# character.
Select the formula cells, right-click the selection and click
Copy.
Right-click the upper right corner destination cell, and click
Paste.
Select the entire used range and press Ctrl+H again to show the Find and Replace dialog box.
In the Find what field, enter the
In the Replace with field enter re-enter the
#evba #etipfree #kingexcel# character to reinstate the formulas.In the Replace with field enter re-enter the
= character.
📤You download App EVBA.info installed directly on the latest phone here : https://www.evba.info/p/app-evbainfo-setting-for-your-phone.html?m=1
Hi, I'm Mr Z-Lib Admin of Z-Lib.click .Thank you so much and I hope you will have an interesting time with Z-Lib.click . Mail: webappninja1@gmail.com - PHONE : +84779313987. 
Leave a Comment