To change the page orientation: 1 Click the Page dialog sheet tab within the Page Setup dialog box. Because the print job is more horizontal than vertical, it would be a good idea to change the orientation from portrait to landscape. Chapter 1 Getting Started with Excel 19įigure 1-14Adding a header to the printed page Page Setup button Page Setup Header dialog box dialog box 6 Click the OK button. 5 Type Yearly Usage Report in the Center section of the Header dialog box as shown in Figure 1-14. You can also write your own you’ll do this now. 3 Excel provides a list of built-in headers that you can select from the Header drop-down list. 2 Click the Header/Footer dialog sheet tab. To add a header to a print job: 1 Click the Page Setup button from the Print Preview tab. To see how this works, adjust the settings for the current print job by adding a header and changing the page layout.

You may add a header or footer to each page, change the orientation from portrait to land- scape, and modify many other features.

You can change these settings for each print job. Table 1-4 describes the variety of options available to you from the PrintPreview tab in the Print Preview window.Table 1-4 Print Preview Options Description Send the document to the printer Button Set up the properties of the printed page Print Zoom in and out of the Preview window Page Setup View the next page in the print job Zoom View the previous page in the print job Next Page Display margins in the Preview window Previous Page Close the Print Preview window Show Margins Close Print PreviewSetting Up the Page The Preview window opens with the default print settings for the work- book. Figure 1-13 The Print Preview Window Print Preview tab Zoom controls to increase/decrease the magnification of the previewed document18 Excel The Print Preview opens as displayed in Figure 1-13. 2 Click the Office button, then click Print, and then click Print Preview. To preview a print job: 1 Verify that Total Usage is still the active worksheet. Try this now with the Total Usage worksheet. With Excel’s Print Preview window, you can view your job before it’s printed, as well as set up the page margins, orientation, and headers and footers. To do this, you can print out selected portions of the workbook.Previewing the Print Job Before sending a job to the printer, it’s usually a good idea to preview the output.

Printing from Excel It would be useful for the chief of interpretation at Kenai Fjords National Park to have a hard copy of some of the worksheets and charts in the Park workbook. You canrefer to Excel’s online Help for more information. If you want to copy a cell range rather than move it, you can use the Copybutton in the above steps, or if you prefer the drag and drop technique,hold down the CTRL key while dragging the cell range to its new location this will create a copy of the original cell range at the new location. 5 Click cell A1 to make A1 the active cell again. The table now appears back in the cell range, B4:F17.

Box plots on excel statplus