Microsoft Office Tutorials and References
In Depth Information
Consolidating by category
Figure 8-82 When you create links to the source worksheets, the consolidation worksheet is
outlined and linking formulas are created in subordinate outline levels.
Note that when you create links, any rows or columns you subsequently add to the source
worksheets are not included in the consolidation. However, it is easy to modify the
consolidation references. Open the Consolidate dialog box, select the reference you want to
change, and click Delete. Then select the modified range, and click Add.
For more information about outlining worksheets, see “Outlining worksheets” earlier in this