Excel 2019 Bible

Chapter 27: Creating and Using Worksheet Outlines 27 When Excel creates a row outline, the summary rows must be all below the da ...

Part IV: Managing and Analyzing Data Figure 27.6 shows a worksheet with a three-level outline of this book. We had to create it ...

Chapter 27: Creating and Using Worksheet Outlines 27 a level number displays the detail for that level, plus any levels with low ...

Part IV: Managing and Analyzing Data FIGURE 27.7 Use the Settings dialog box to adjust the position of the outline symbols. Hidi ...

637 C H A P T E R 28 Linking and Consolidating Worksheets IN THIS CHAPTER Using various methods to link workbooks Consolidating ...

Part IV: Managing and Analyzing Data Linking has its downside, however. External reference formulas are somewhat fragile, and ac ...

Chapter 28: Linking and Consolidating Worksheets 28 If the workbook name or the sheet name in the reference includes one or more ...

Part IV: Managing and Analyzing Data Pasting links Pasting links provides another way to create external reference formulas. Thi ...

Chapter 28: Linking and Consolidating Worksheets 28 Values dialog box, which resembles the Open dialog box. If you click Cancel, ...

Part IV: Managing and Analyzing Data FIGURE 28.3 The Edit Links dialog box You can also access the Edit Links dialog box by choo ...

Chapter 28: Linking and Consolidating Worksheets 28 click the Startup Prompt button and then select the option that describes ho ...

Part IV: Managing and Analyzing Data Avoiding Potential Problems with External Reference Formulas Using external reference formu ...

Chapter 28: Linking and Consolidating Worksheets 28 It’s easy to determine the source workbooks for a particular dependent workb ...

Part IV: Managing and Analyzing Data Using Intermediary links Excel doesn’t place many limitations on the complexity of your net ...

Chapter 28: Linking and Consolidating Worksheets 28 Time to Rethink Your Consolidation Strategy? If you’re reading this chapter, ...

Part IV: Managing and Analyzing Data You can include any number of external references in this formula, up to the 8,000-charac- ...

Chapter 28: Linking and Consolidating Worksheets 28 Choose Home ➪ Clipboard ➪ Paste ➪ Paste Special. The Paste Special dialog b ...

Part IV: Managing and Analyzing Data The following is a description of the controls in this dialog box: Function drop-down list ...

Chapter 28: Linking and Consolidating Worksheets 28 FIGURE 28.7 Three worksheets to be consolidated Enter the reference for the ...

Part IV: Managing and Analyzing Data Select the Create Links to Source Data check box to make Excel create an out- line with ex ...