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.