Copying Formulas While Keeping Their Relative and Absolute References - KING OF EXCEL

Monday, January 20, 2020

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 = 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 # character to reinstate the formulas.
In the Replace with field enter re-enter the = character.
#evba #etipfree #kingexcel
📤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

No comments:

Post a Comment