O'Reilly logo

Microsoft Excel X for Mac OS X: Visual QuickStart Guide by Maria Langer

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Consolidations

The Consolidate command lets you combine data from multiple sources. Excel lets you do this in two ways:

  • Consolidate based on the arrangement of data. This is useful when data occupies the same number of cells in the same arrangement in multiple locations (Figure 3).

  • Consolidate based on identifying labels or categories. This is useful when the arrangement of data varies from one source to the next.

Tip

  • With either method, Excel can create links to the source information so the consolidation changes automatically when linked data changes.

To consolidate based on the arrangement of data

1.
Select the cell(s) where you want the consolidated information to go (Figure 32).
Figure 32. Select the cells in which you want the consolidated ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required