• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 5. Consolidate the Results > Check the Consolidation

Check the Consolidation

When you consolidate multiple worksheets as instructed here, you create a new worksheet with “3-D” references to the source worksheets. Because Excel has to display contents from all of the source cells, it automatically displays the consolidation as an outline with the outline collapsed so only the total for each category appears.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint