…We're looking at a workbook called State Link.…There are three other files open.…So on the view tab, switch windows, we've…got a Utah, Colorado, and New Mexico workbook available.…They're all open.…And in column B here, we want to actually, get…totals from each of those different workbooks to display right here.…These are sometimes called linkage formulas.…We can start at the actual source data.…So by way of Switch Windows, we can go to Colorado first, the source cell is H4.…
We can copy this, Ctrl+C or right-click and…Copy, then, by way of Ctrl+tab or possibly.…The view tab again back to switch windows.…We'll go back to our state link file, click here, and, by right-clicking and…choosing paste special, or Ctrl+Alt+V, the keystroke shortcut, choose Paste Link.…Notice that the formula contains a cell reference, then…the sheet name, and then the actual file name.…
And although not necessary, you might want to display this formula to the right.…There's a new function in Excel 2013, called formula text.…If you type equal f o, you'll see it immediately, right there, you…
- Explain how to recover a deleted worksheet.
- Identify the purpose of the Protect Workbook command.
- Summarize the steps to view more than one worksheet at the same time.
- Recognize the steps for grouping nonadjacent worksheets.
- Explain the purpose of PivotTables and the Consolidate command.
- Recall the selection that allows users to display the name of all sourced workbooks.