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

Chapter 13. Using Multiple Worksheets > Consolidating to a Sheet

Consolidating to a Sheet

When successive sheets of a workbook contain the same arrangement of data, you can sum ranges that extend "down" from sheet to sheet rather than across a single sheet. This is called 3D referencing (Figure 13.15), and it's the preferred method of consolidation.

Figure 13.15. With 3D referencing, values in corresponding cells from different sheets are combined in one consolidation sheet.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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