Click Print Preview. The page is centered horizontally, as shown below. Click the Back button to leave Backstage. SAVE the workbook. PAUSE. Leave the workbook open to use in the next exercise. Step by Step 19: Set a Worksheet’s Orientation GET READY. USE the workbook from the previous exercise. Ensure Sheet1 is active and in Normal view. On the PAGE LAYOUT tab, in the Page Setup group, click and then click Orientation Landscape. Click the FILE tab, and then click Print. Click through the pages to see the worksheet in Landscape orientation. If you decided to keep this orientation, you would need to adjust page breaks to display all content properly. the Back button to leave Backstage. Repeat Step 2 to change the orientation back to Portrait. Leave Excel open to use in the next exercise. Step by Step 20: Scale a Worksheet to Fit on a Printed Page GET READY. USE the workbook from the previous exercise. Ensure Sheet1 is active and in Normal view. On the PAGE LAYOUT tab, in the Page Setup group, click Orientation and verify that Portrait is selected. In the Scale to Fit group, click the Height arrow and select 1 page. The scale of the worksheet is reduced so that all rows fit on the same page.
Click Print Preview. The page is centered horizontally, as shown below. Click the Back button to leave Backstage. SAVE the workbook. PAUSE. Leave the workbook open to use in the next exercise. Step by Step 19: Set a Worksheet’s Orientation GET READY. USE the workbook from the previous exercise. Ensure Sheet1 is active and in Normal view. On the PAGE LAYOUT tab, in the Page Setup group, click Orientation and then click Landscape. Click the FILE tab, and then click Print. Click through the pages to see the worksheet in Landscape orientation. If you decided to keep this orientation, you would need to adjust page breaks to display all content properly. the Back button to leave Backstage. Repeat Step 2 to change the orientation back to Portrait. Leave Excel open to use in the next exercise. Step by Step 20: Scale a Worksheet to Fit on a Printed Page GET READY. USE the workbook from the previous exercise. Ensure Sheet1 is active and in Normal view. On the PAGE LAYOUT tab, in the Page Setup group, click Orientation and verify that Portrait is selected. In the Scale to Fit group, click the Height arrow and select 1 page. The scale of the worksheet is reduced so that all rows fit on the same page.
step_by_step_7-_excel.docx