Excel 2010 Bible

Chapter 25: Using Data Validation 579 Therefore, the drop-down list displayed in F2 depends on the value displayed in cell E2. F ...

...

581 CHAPTER Creating and Using Worksheet Outlines IN THIS CHAPTER Introducing worksheet outlines Creating an outline Using outli ...

Part IV: Using Advanced Excel Features 582 FIGURE 26.1 A simple sales summary with subtotals. FIGURE 26.2 The worksheet after cr ...

Chapter 26: Creating and Using Worksheet Outlines 583 FIGURE 26.3 The worksheet after collapsing the outline to the second level ...

Part IV: Using Advanced Excel Features 584 On the CD You can find the workbook used in the preceding examples on this book’s CD- ...

Chapter 26: Creating and Using Worksheet Outlines 585 In this case, each budget item (for example, airfare and hotel expenses) i ...

Part IV: Using Advanced Excel Features 586 To have Excel create an outline, move the cell pointer anywhere within the range of d ...

Chapter 26: Creating and Using Worksheet Outlines 587 Note If you select a range of cells (rather than entire rows or columns) b ...

Part IV: Using Advanced Excel Features 588 Adding data to an outline You may need to add additional rows or columns to an outlin ...

589 CHAPTER Linking and Consolidating Worksheets IN THIS CHAPTER Various methods of linking workbooks Consolidating multiple wor ...

Part IV: Using Advanced Excel Features 590 workbook. You can create a summary workbook that first uses link formulas to retrieve ...

Chapter 27: Linking and Consolidating Worksheets 591 If the workbook name or the sheet name in the reference includes one or mor ...

Part IV: Using Advanced Excel Features 592 Working with External Reference Formulas This section discusses some key points that ...

Chapter 27: Linking and Consolidating Worksheets 593 What if you choose to update the links, but the source workbook is no longe ...

Part IV: Using Advanced Excel Features 594 FIGURE 27.3 The Edit Links dialog box. Changing the startup prompt When you open a wo ...

Chapter 27: Linking and Consolidating Worksheets 595 list, and then click the Update Values button. Excel updates the link formu ...

Part IV: Using Advanced Excel Features 596 Renaming or moving a source workbook If you rename the source document or move it to ...

Chapter 27: Linking and Consolidating Worksheets 597 The following link formula refers to cell C21 on Sheet1 in the budget.xlsx ...

Part IV: Using Advanced Excel Features 598 If the worksheets bear little or no resemblance to each other, your best bet may be t ...