661
Using Links to Automatically Update or Consolidate Worksheet Data
To remove multiple panes and return to a single editing window, you can do any of the fol-
lowing: Choose Window, Remove Split; double-click the split bar; or click the bar and drag
it off the worksheet window.
Using Links to Automatically Update or
Consolidate Worksheet Data
Use links to share data between cells or ranges in one worksheet and another location in the
same workbook or a different workbook. Just as a formula displays the results of a calcula-
tion, a link looks up data from another location and displays it in the active cell.
Links offer a powerful technique for consolidating ...