1 / 10

Excel Chapter 9

Excel Chapter 9. Part 6: Saving Custom Views and Formatting a Worksheet Background. 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

zarek
Télécharger la présentation

Excel Chapter 9

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  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

More Related