mos 2010 study guide for microsoft phần 4

Các tập tin thực hành cho những công việc này nằm trong thư mục tập tin Word \ Objective1 thực hành. Lưu kết quả của nhiệm vụ trong cùng một thư mục. Mở phiên bản tài liệu và lưu nó như là MyVersions. Cấu hình | 1 Managing the Worksheet Environment 169 To print a single worksheet 1. Display the worksheet you want to print. 2. On the Print page of the Backstage view in the Settings area display the first Print list and then click Print Active Sheets. To print specific worksheets 1. Display the first worksheet in the workbook that you want to print. 2. Select additional worksheets in one of these ways o To select adjacent worksheets press Shift and then click the tab of the last worksheet in the workbook that you want to print. o To select nonadjacent worksheets press Ctrl and then click the tab of each additional worksheet you want to print. 3. On the Print page of the Backstage view in the Settings area display the first Print list and then click Print Active Sheets. Tip When multiple worksheets are selected Group appears in the title bar. Many commands are not available when a group of worksheets is active. To release the group selection click the tab of any worksheet that is not part of the group. To print a portion of a worksheet without defining a print area 1. In the worksheet select the range of cells you want to print. 2. On the Print page of the Backstage view in the Settings area display the first Print list and then click Print Selection. To define a selected range as the print area On the Page Layout tab in the Page Setup group click the Print Area button and then click Set Print Area. To add a selected range to the print area On the Page Layout tab in the Page Setup group click the Print Area button and then click Add to Print Area. Tip The Add To Print Area option will not be displayed if the area of the worksheet designated as the print area is currently selected. 170 Exam 77-882 Microsoft Excel 2010 To remove a range from the print area 1. On the Page Layout tab click the Page Setup dialog box launcher. 2. On the Sheet page of the Page Setup dialog box change the range reference in the Print area box and then click OK. To clear the print area On the Page .