One-way links

The easiest way to set up a one-way link is to type it directly into the destination cell. For example, if A1 contains 123, type the formula

=A1

in any other cell, say E10. The contents of E10 will always be the same as A1. This is identical to a standard spreadsheet formula, so =A1 + 10 is also valid.

As an alternative, you can use a paste special operation to achieve the same result. For example:

  1. Click in cell A1

  2. Select Copy by right-clicking your mouse

  3. Click in cell E10, which is to contain the linking expression

  4. Select Paste Special by right-clicking your mouse

  5. Select Paste Link from the "Paste Special" dialog

See also:

One-way links between documents

Two-way or hot links