Links are a powerful tool for maintaining data integrity. By updating a source, you update all linked destinations. You can create a text link by copying a single cell and pasting it into a document, outside of a table. This link can then be included into bodies of text as desired.
Creating a Link
To create a link:
- Use the keyboard shortcut Ctrl+C to copy a cell or range of cells from a Spreadsheet, Workbook, or table.
- Paste in the target Spreadsheet, Workbook, or table.
- After pasting, click the blue clipboard and choose Create Links.
- Choose the desired option from the Create Links list.
- Click Apply to finalize your link.
You can also link to lines of text by creating source links.
To create a source link:
- Select the line(s) of text you want to link from. This text must be outside of a table. You can link a word, phrase, paragraph or span multiple paragraphs. You can also edit the source in-line with the surrounding text.
- Right-click your text and select Create Source Link from the menu.
When you create a link, you can choose from the following options:
- Cells with Values - Creates links to selected cells that contain a value.
- Linked Cells - Creates links to selected cells which already have links.
- All Cells - Creates links to all selected cells, including blanks cells.