XL: Label Missing from Upper-Left Corner of Consolidation Table

             Number
   Alpha     5
   Bravo     7
   Charlie   9
				

   Name      Number
   Alpha     5
   Bravo     7
   Charlie   9
				

MORE INFORMATION

The Consolidate feature in Microsoft Excel allows you summarize data from multiple, identically arranged tables. To see an example that uses the Consolidate feature and demonstrates problem described in the "Symptoms" section in this article, follow these steps:

1. In Microsoft Excel, create a new workbook. Enter the following values in the specified worksheets:

         Sheet1                     Sheet2
         ------------------------   ------------------------
   
         A1: Name      B1: Number   A1: Name      B1: Number
         A2: Alpha     B2: 1        A2: Alpha     B2: 4
         A3: Bravo     B3: 2        A3: Bravo     B3: 5
         A4: Charlie   B4: 3        A4: Charlie   B4: 6
   						

2. Click Sheet3, and then select cell A1.
3. On the Data menu, click Consolidate. In the Consolidate dialog box, follow these steps:
   
   
   1. Click Sheet1. Select the cell range A1:B4. Click Add.
   2. Click Sheet2. Select the cell range A1:B4. Click Add.
   3. Click to select both the Top Row and the Left Column check boxes in the dialog box.
   4. Click OK.

The following consolidation table is created in Sheet3:

   A1:           B1: Number
   A2: Alpha     B2: 5
   A3: Bravo     B3: 7
   A4: Charlie   B4: 9
				

Note that the values in the table (5, 7, 9) are the sums of the respective values in cells B2, B3, and B4 in the tables in Sheet1 (1, 2, 3) and Sheet2 (4, 5, 6).

Note also that the label "Name" is missing from cell A1. If you follow the steps in the "Workaround" section, the missing label appears correctly, for example:

   A1: Name      B1: Number
   A2: Alpha     B2: 5
   A3: Bravo     B3: 7
   A4: Charlie   B4: 9