Custom paste function allowing cells to keep original references - Next generation tools for Microsoft Office
  1. Ampler.io
  2. Resources
  3. Excel tutorials
  4. Insert for Excel
  5. Custom paste function allowing cells to keep original references

Custom paste function allowing cells to keep original references

  • Paste exact cell references even when they are not locked
  • Paste values or links
  • Choose to paste formatting

  1. Select the cells to copy and press CTRL+C. Select the area you with to copy to
  2. Click ‘Paste special‘ and select ‘Exact content‘ to preserve unlocked formulas. Click OK
Was this article helpful?
Yes No

Related Articles

Can we help?

Contact us
Dortheavej 8
2400 Copenhagen
Denmark
hello@ampler.io

Ampler

Why Ampler?

Platform

Resources

Get Started

Try free
×

This website uses cookies in order to improve the user experience. When you continue to use this site, you accept the use of cookies. Read more about our cookie policy here.

 Ok, close this message