Use the navigator toolbar to reference cells from one sheet
to another sheet in the same spreadsheet. The cells can be inserted
as copies of cells, as links from cells in the same sheet, or as hyperlinks
from cells in another sheet. The range to be inserted must be defined
with a name.
- Open the spreadsheet that contains the source cells and
select them.
- Name the source range. Click .
- Save the file, but do not close it.
- Open the target sheet in which you want to link to something.
- Click .
- Expand Range names and select the
source object.
- Right-click and select Drag Mode.
Then select the type of reference that you want: a hyperlink, link,
or copy.
- Drag the selected source object into the cell of the target
sheet where you want to insert the reference.