Excel Chapter 9

1. Excel Chapter 9 Part 6: Saving Custom Views and Formatting a Worksheet Background

2. Saving a Custom View of a Workbook • Resize the FasToast Ovens Travel Expenses workbook window as shown in Figure 9–91 • Click the View tab on the Ribbon • Click the Custom Views button on the Ribbon to display the Custom Views dialog box • Click the Add button to display the Add View dialog box • Type Expenses in the Name text box Microsoft Office 2007: Comprehensive Concepts and Techniques - Windows Vista Edition

3. Saving a Custom View of a Workbook • Click the OK button • Click the Maximize button on the FasToast Ovens Travel Expenses workbook title bar • Click the Custom Views button on the Ribbon to display the Custom Views dialog box • Click Expenses in the Views list and then click the Show button to resize the workbook to the size saved in the Expenses view Microsoft Office 2007: Comprehensive Concepts and Techniques - Windows Vista Edition

4. Saving a Custom View of a Workbook Microsoft Office 2007: Comprehensive Concepts and Techniques - Windows Vista Edition

5. Formatting a Worksheet Background • Click the Maximize button on the FasToast Ovens Travel Expenses workbook title bar • Click the Page Layout tab on the Ribbon • Click the Background button on the Ribbon to display the Sheet Background dialog box • If necessary, navigate to where you have saved your student data files • Click the file name, FasToast Travel Microsoft Office 2007: Comprehensive Concepts and Techniques - Windows Vista Edition

6. Formatting a Worksheet Background • C lick the Background button on the Ribbon to display the Sheet Background dialog box • If necessary, select UDISK 2.0 (E:) in the Address bar • C lick the file name, FasToast Travel Microsoft Office 2007: Comprehensive Concepts and Techniques - Windows Vista Edition

7. Formatting a Worksheet Background Microsoft Office 2007: Comprehensive Concepts and Techniques - Windows Vista Edition

8. Quitting Excel • Remove the Compare and Merge Workbooks button from the Quick Access Toolbar • Click the Close button on the right side of the title bar • If Excel displays the Microsoft Office Excel dialog box, click the No button Microsoft Office 2007: Comprehensive Concepts and Techniques - Windows Vista Edition

9. Summary • Import data from a text file, an • Access database, a Web page, and a Word Document • Transpose data while pasting it • C onvert text to columns • Replicate formulas • Explain sharing and collaboration techniques • Insert, edit, and delete a comment Microsoft Office 2007: Comprehensive Concepts and Techniques - Windows Vista Edition

10. Summary • Track changes and share a workbook • Accept and reject tracked changes made to a workbook • Analyze worksheet data using a PivotTable and a PivotChart • Compare and merge shared workbooks • Analyze worksheet data using a trendline • Save a custom view of a worksheet and format a worksheet background Microsoft Office 2007: Comprehensive Concepts and Techniques - Windows Vista Edition