Excel 2010 Bible

Part I: Getting Started with Excel

72

FIGURE 4.2

Excel enables you to select noncontiguous ranges.

Note
Noncontiguous ranges differ from contiguous ranges in several important ways. One obvious difference is that
you can’t use drag-and-drop methods (described later) to move or copy noncontiguous ranges. n

Selecting multisheet ranges .......................................................................................

In addition to two-dimensional ranges on a single worksheet, ranges can extend across multiple

worksheets to be three-dimensional ranges.

Suppose that you have a workbook set up to track budgets. A common approach is to use a sepa-

rate 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 val-

ues. The Totals sheet contains formulas that compute the sum of the corresponding items in the

three departmental worksheets.

On the CD
This workbook, named budget.xlsx, is available on the companion CD-ROM. n