Microsoft Office Tutorials and References
In Depth Information
6. Viewing and Printing Worksheets and Workbooks
6. Viewing and Printing Worksheets and Workbooks
What You’ll Do
Set Up the Page
Adjust Page Margins
Add Headers and Footers
Insert Page Breaks
Customize Worksheet Printing
Set the Print Area
Preview a Worksheet
Print a Worksheet and Workbook
Create a PDF Document
Create an XPS Document
When your Microsoft Excel worksheet is completed, you can preview and print its con-
tents. While previewing the worksheet, you might find that rows of data might flow better
on one page or the other. You can add page breaks to segment what you want to appear on
a page. You can insert page breaks to control what you print on each page. You can change
the orientation of the page from the default of portrait (vertical) to landscape (horizontal).
This is helpful when you have wide or multiple columns that would look better on one
page. You can also adjust your margins to better fit the worksheet on the page. Previewing
a worksheet before printing saves you time and money by not printing unnecessary copies.
After you make layout adjustments you can add headers and footers on the page in Page
Layout view, which lets you focus on how your worksheet is going to look when you print
it. Headers are typically a descriptive title about your worksheet or workbook. Footers can
include date printed, page numbers, or other company related information. You can add ad-
ditional elements to your printout by showing gridlines or column letters and row numbers.
When you’re ready to print your work, you can quickly print the entire worksheet, or
print only part of the worksheet. Excel provides options to set the print area and customize
what you want to print. For example, you might want to print a different range in a work-
sheet for different people. After you set the print area, you can choose to print your work-
Search JabSto ::

Custom Search