1.4 PrintingLearning Objectives
Show Once you have completed a workbook, it is good practice to select the appropriate settings for printing. These settings are in the Page Layout tab of the Ribbon and discussed in this section of the chapter. Page SetupFollow-along file: Excel Objective 1.0 (Use file Excel Objective 1.14 if you are starting with this skill.) Before you can properly print the worksheets in a workbook, you must establish appropriate settings. The following steps explain several of the commands in the Page Layout tab of the Ribbon used to prepare a worksheet for printing:
Why?Use Print Settings Because professionals often share Excel workbooks, it is a good practice to select the appropriate print settings in the Page Layout tab even if you do not intend to print the worksheets in a workbook. It can be extremely frustrating for recipients of a workbook who wish to print your worksheets to find that the necessary print settings have not been selected. This may reflect poorly on your attention to detail, especially if the recipient of the workbook is your boss. Figure 1.62 Page Layout Commands for Printing Table 1.2 Printing Resources: Purpose and Use for Page Setup Commands
Headers and FootersFollow-along file: Excel Objective 1.0 (Use file Excel Objective 1.15 if you are starting with this skill.) When printing worksheets from Excel, it is common to add headersSpace at the top of a printed worksheet that contains information such as the date, page number, file name, company name, and so on. and footersSpace at the bottom of a printed worksheet that contains information such as the date, page number, file name, company name, and so on. to the printed document. Information in the header or footer could include the date, page number, file name, company name, and so on. The following steps explain how to add headers and footers to the Excel Objective 1.0 workbook:
Printing Worksheets and WorkbooksFollow-along file: Excel Objective 1.0 (Use file Excel Objective 1.16 if you are starting with this skill.) Once you have established the print settings for the worksheets in a workbook and have added headers and footers, you are ready to print your worksheets. The following steps explain how to print the worksheets in the Excel Objective 1.0 workbook:
Key Takeaways
Exercises
Which tab contain the Print command?Click the File tab to go to Backstage view. Select Print. The Print pane appears, with the print settings on the left and the Preview on the right.
Where is the Print area on Excel?How to check the print area in Excel. When you click "File" in the top menu bar and the "Print," you'll see a preview of what Excel will print. ... . You can also check your print area in the "Page Setup" window in the top menu.. Click on the "Page Setup" button. ... . Click on "Sheet" on the right.. What are the printing option in Excel?Print one or several worksheets. Select the worksheets that you want to print.. Click FILE > Print. You can also press Ctrl+P.. Click the Print button, or adjust Settings before you click the Print button.. How do you Print Excel Online?Print in Excel for the web. Select the cells or chart you want to print, and then go to File > Print. ... . Click Print for a preview.. If you change your mind about printing a selected area, choose the Entire Sheet print option and click Print.. If the final print preview looks right, click Print.. |