Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.
Printer-Friendly VersionPrinter-Friendly Version
Change a data consolidation of multiple worksheets
 

  1. Click the upper-left cell in the consolidated data.

  2. On the Data menu, click Consolidate.

    You can change the consolidation only if you did not previously select the Create links to source data check box. If the check box is selected, click Close, and re-create the consolidation.

  3. Do one or more of the following:

    ShowAdd another source range to the consolidation

    The new source range must have either data in the same positions or column labels that match those in the other ranges in the consolidation.

    1. Click the Reference box.

    2. Click the sheet tab of the first range to consolidate.

    3. Type the name you gave the range, or select the range.

    4. Click Add.

    ShowAdjust the size or shape of a source range

    1. Under All references, click the source range you want to change.

    2. In the References box, edit the selected reference.

    3. Click Add.

    ShowDelete a source range from the consolidation

    1. Under All references, click the source range you want to delete.

    2. Click Delete.

    ShowMake the consolidation update automatically

    Note  Once you make this change, you can't add, change, or delete any of the source ranges.

    Select the Create links to source data check box.

  4. To update the consolidation with the changes, click OK.

Printer-Friendly VersionPrinter-Friendly Version
© 2009 Microsoft Corporation. All rights reserved.