This option connects two cells so that changes in
the original are echoed in the linked cell. It’s handy when you need to use a single changing figure in multiple spots around a worksheet.
- Click the cell you’re linking from and click Copy.
- Click the destination cell and then the arrow next to the Paste button.
- Choose Paste Link.
- Now whenever the original cell’s value changes, the linked cell’s value is automatically updated, too.