With the help
of the Navigator, you can reference cells
from one sheet to another sheet in the same spreadsheet. The cells
can be inserted as a copy, link or hyperlink. The range to be inserted
must be defined with a name in the original file so that it can be
inserted in the target file.
- Open the spreadsheet
that contains the source cells.
- To set the
source range as the range, select the cells
and click . Save the source document,
and do not close it.
- Open the sheet in which
you want to insert something.
- Open the Navigator
by clicking .
- Click plus(+) in front of Range
names and
select the source object.
- Right-click and select Drag
Mode.
Then select the type of the reference that you want, a hyperlink,
link, or copy.
- Drag the selected source object
into the cell of the current
sheet where you want to insert the reference.