IBM Lotus Symphony


Using Drag and Drop to Create Cells References

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.

  1. Open the spreadsheet that contains the source cells.
  2. To set the source range as the range, select the cells and click Create > Name > Define. Save the source document, and do not close it.
  3. Open the sheet in which you want to insert something.
  4. Open the Navigator by clicking View > Navigator.
  5. Click plus(+) in front of Range names and select the source object.
  6. Right-click and select Drag Mode. Then select the type of the reference that you want, a hyperlink, link, or copy.
  7. Drag the selected source object into the cell of the current sheet where you want to insert the reference.

Product Feedback | Additional Documentation | Trademarks