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

Chapter 5. Consolidate the Results > Consolidate pp.61–64

Consolidate pp.6164

  • Because each worksheet in the consolidation has a slightly different organization—remember, we added a row in one and deleted a row in another—you must turn on the Left column check box to properly consolidate. Doing so tells Excel to sum values based on category name (the row label) rather than row position.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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