Microsoft Office Tutorials and References
In Depth Information
Consolidating Your Data—Getting It All Together
Note in addition that a fourth sheet, containing the same labels but no data, is supplied as well. If you
were consolidating your own sheets you’d need to draw up such a sheet, because this is the one on
which the consolidated results will appear. Then to begin consolidating, select cells B5:B8 in the
Consolidated Data sheet (Figure 7–25):
Figure 7–25. The Consolidated data sheet—marking out the range in which the consolidation results will
appear
Then click the Data tab Consolidate in the Data Tools button group. You’ll see (Figure 7–26):
Figure 7–26. The Consolide dialog box
The options presented here require a bit of explanation. You can carry out two kinds of
consolidation—consolidation by position and consolidation by category. We’re going to start with
 
Search JabSto ::




Custom Search