How to Use Paste Link in Excel – 2022

Paste link is copying the range of a workbook’s sheet (with or without text) and linking it to another worksheet of the same workbook or another workbook’s sheet.

Doing so will automatically update the content in the pasted range when you update or enter the content in the copied range.

Select any range that is empty or contains text, and then right-click on the range and click copy

Copy Range of Cells in a Worksheet
Copy Range of Cells in a Worksheet

Switch to a different worksheet in the same or different workbook

Use the shortcut key (ctrl+alt+v) to open and paste the special dialogue box or right-click and click paste special

Right click for Paste Special Option
Right-click for Paste Special Option

Then click on the “Paste Link” or press “L“. Now a link will be posted.

Right click for Paste Special Option
Click Paste Link on a Dialogue Box

Now switch to the copied worksheet and update or type the text you want

Link from one worksheet to another worksheet in Excel
Link from one worksheet to another worksheet in Excel

Now if you notice the area (sheet B) where the link is pasted, the text here will be updated automatically as in Sheet A.

How to link one worksheet to another in Excel

Copy the range of a workbook’s sheet (with or without text) and link it to another worksheet of the same workbook or another workbook’s sheet. Doing so will automatically update the content in the pasted range when you update or enter the content in the copied range.

Share