Part I: Getting Started with Excel
FIGURE 4.2
Excel enables you to select noncontiguous ranges.
Selecting multisheet ranges
In addition to two-dimensional ranges on a single worksheet, ranges can extend across mul-
tiple worksheets to be three-dimensional ranges.
Suppose you have a workbook set up to track budgets. One approach is to use a separate
worksheet for each department, making it easy to organize the data. You can click a sheet
tab to view the information for a particular department.
Figure 4.3 shows a simplified example. The workbook has four sheets: Totals, Operations,
Marketing, and Manufacturing. The sheets are laid out identically. The only difference is
the values. The Totals sheet contains formulas that compute the sum of the corresponding
items in the three departmental worksheets.
