- Paste exact cell references even when they are not locked
- Paste values or links
- Choose to paste formatting
- Select the cells to copy and press CTRL+C. Select the area you with to copy to
- Click ‘Paste special‘ and select ‘Exact content‘ to preserve unlocked formulas. Click OK