Skip to content
Skip to breadcrumbs
Skip to header menu
Skip to action menu
Skip to quick search

Welcome to FreeSoftwareServers Confluence Wiki

Skip to end of banner Go to start of banner

Copy Excel Formulas without changing references

Skip to end of metadata

Created by freesoftwareservers on Dec 03, 2020

Go to start of metadata

https://www.exceltip.com/excel-text-formulas/copying-formulas-from-a-range-of-cells-without-changing-the-absolute-or-relative-references.html

Select cells, CTRL + H (Find and Replace), replace = with #. Copy and paste cells and Find and place # with =.

No labels

This site is just a Tech Blog, nothing is guaranteed!