• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Linking Data

A link can be as simple as a reference to a cell on another worksheet, or it can be part of a formula. You can link cells between sheets within one workbook or between different workbooks. Cell data to be linked is called the source data. The cell or range linked to the source data is called the destination cell or destination range. If you no longer want linked data to be updated, you can break a link easily. Create links instead of making multiple identical entries; it saves time and ensures your entries are correct.

Create a Link Between Worksheets or Workbooks

Select the cell or range that contains the source data.

Click the Copy button on the Standard toolbar.

Click the sheet tab where you want to link the data.

Select the destination cell or destination range.

Click the Paste button on the Standard toolbar.

Click the Paste Options button, and then click Link Cells.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint