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

Chapter 16. Special Excel Techniques > Consolidating to a Sheet

Consolidating to a Sheet

When successive sheets of a workbook contain the exact same arrangement of data, you can sum ranges that extend “down” from sheet to sheet data rather than across a single sheet. This process is called 3-D referencing (Figure 16.10).

Figure 16.10. 3-D referencing.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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