Excel 2010 Bible

Chapter 27: Linking and Consolidating Worksheets 599 Consolidating worksheets by using Paste Special Another method of consolida ...

Part IV: Using Advanced Excel Features 600 Consolidating worksheets by using the Consolidate command For the ultimate in data co ...

Chapter 27: Linking and Consolidating Worksheets 601 l (^) Use Labels In check boxes: Use to instruct Excel to perform the conso ...

Part IV: Using Advanced Excel Features 602 On the CD These workbooks are available on the companion CD-ROM. The files are named ...

Chapter 27: Linking and Consolidating Worksheets 603 FIGURE 27.8 The result of consolidating the information in three workbooks. ...

Part IV: Using Advanced Excel Features 604 Refreshing a consolidation When you choose the option to create formulas, the externa ...

605 CHAPTER Excel and the Internet IN THIS CHAPTER Saving Excel files in HTML format Creating hyperlinks Importing data from a W ...

Part IV: Using Advanced Excel Features 606 Understanding the Different Web Formats You can save an Excel workbook so that it’s v ...

Chapter 28: Excel and the Internet 607 Creating an HTML file To save a workbook as an HTML file: (Optional but recommended) Sav ...

Part IV: Using Advanced Excel Features 608 FIGURE 28.2 Viewing the HTML file in a browser. If you save your work in HTML format, ...

Chapter 28: Excel and the Internet 609 FIGURE 28.3 Viewing the single file Web page in Internet Explorer. Opening an HTML File E ...

Part IV: Using Advanced Excel Features 610 Working with Hyperlinks A hyperlink is clickable text that provides a quick way to ju ...

Chapter 28: Excel and the Internet 611 The appearance of hyperlinks in cells is controlled by two styles in the Style Gallery. T ...

Part IV: Using Advanced Excel Features 612 Using Web Queries Excel enables you to pull in data contained in an HTML file by perf ...

Chapter 28: Excel and the Internet 613 FIGURE 28.6 Use the New Web Query dialog box to specify the source of the data. FIGURE 28 ...

Part IV: Using Advanced Excel Features 614 Other Internet-Related Features Excel offers a few other Internet-related features, w ...

615 CHAPTER Sharing Data with Other Office Applications IN THIS CHAPTER Understanding data sharing Pasting and linking data Embe ...

Part IV: Using Advanced Excel Features 616 Here are the general steps that are required to copy from one application to another: ...

Chapter 29: Sharing Data with Other Office Applications 617 Cross-Reference See Chapter 4 for more information about the Office ...

Part IV: Using Advanced Excel Features 618 FIGURE 29.1 A Paste Options Smart Tag appears when you paste Excel 2010 data into a W ...