Creating Links

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 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:

1
Use the keyboard shortcut Ctrl+C to copy a cell or range of cells from a Spreadsheet, Workbook, or table,
2
Paste in the target Spreadsheet, Workbook, or table.
3
After pasting, click the blue clipboard and choose Create Links.
4
Choose the desired option from the Create Links list.
5
Click Apply to finalize your link. Create Link options

Link Options

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.

What's Next