Show All

Change a data consolidation

• If you used 3-D references or other formulas to consolidate the data, you can change the consolidation by editing the formulas.
• If you used the Consolidate command on the Data menu, you can change the consolidation by using the following steps:

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:

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

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

   Delete a source range from the consolidation

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

   2. Click Delete.

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