linking cells

[Fanny]

To link cells, help says to click cell containing data linking to, then click copy icon, then click cell linking from and click paste. Then click Paste Options and link the cells, but where is Paste Options, without doing extra steps, so I can just click it?

Can someone please just walk me thru one example, from beginning to end, to link two cells in the same worksheet?

Thank you.

 

[Justinlabenne]

You could just type in an = sign in the cell getting the link, and then select the cell to link to.

Paste options is next to the Copy icon on the toolbar, it should have a drop down arrow with options available, one which is PasteLink