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.


  • 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

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 ...

Get Microsoft Excel X for Mac OS X: Visual QuickStart Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.