Referencing Cells by Drag-and-Drop

With the help of the Navigator you can reference cells from one sheet to another sheet in the same document or in a different document. 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 document that contains the source cells.
2. To set the source range as the range, select the cells and choose Sheet - Named Ranges and Expressions - 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. In the lower box of the Navigator select the source file.
5. In the Navigator, the source file object appears under "Range names".
6. Using the Drag Mode icon in Navigator, choose whether you want the reference to be a hyperlink, link, or copy.
7. Click the name under "Range names" in the Navigator, and drag into the cell of the current sheet where you want to insert the reference.

This method can also be used to insert a range from another sheet of the same document into the current sheet. Select the active document as source in step 4 above.

LibreOffice Books

Impressum (Legal Info) | Privacy Policy | Statutes (non-binding English translation) - Satzung (binding German version) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Mozilla Public License v2.0. “LibreOffice” and “The Document Foundation” are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy. LibreOffice was based on OpenOffice.org.

Help content debug info:

Title is: Referencing Cells by Drag-and-Drop