IBM Lotus Symphony


Referencing Cells from One Sheet to Another

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.

  1. Open the spreadsheet that contains the source cells and select them.
  2. Name the source range. Click Create > Names > Define.
  3. Save the file, but do not close it.
  4. Open the target sheet in which you want to link to something.
  5. Click View > Navigator.
  6. Expand Range names and select the source object.
  7. Right-click and select Drag Mode. Then select the type of reference that you want: a hyperlink, link, or copy.
  8. Drag the selected source object into the cell of the target sheet where you want to insert the reference.

Product Feedback | Additional Documentation | Trademarks