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
Try free