This module discusses printing your worksheets. First, the module covers the Page Layout tab for setting up the worksheet page. Next, the module goes into more detail on setting up your pages. The module discusses how to use Print Preview, Finally, the module explains how to print your worksheets.
The Page Layout tab is used to set up your page. There following groups of buttons are on this ribbon:
- Page Setup
- Scale to Fit
- Sheet Options
Shown here is the Page Layout tab on the Ribbon.
The Page Setup group on the Page Layout tab of the Ribbon includes several tools to help you set up your page. You can control the margins, orientation, and size of your page. You can also control the print area, if you don’t want to print all of the contents of your worksheet. Finally, there is another opportunity to control page breaks. You can also include a background and printing titles.
Use the following procedure to use custom margins.
- Select Custom Margins from the Margins tool on the Page Layout tab of the Ribbon.
Excel displays the Page Setup dialog box.
- Use the up and/or down arrows to control each of the margins (in inches). When have finished, select OK.
Shown here is the Print tab in the Backstage View.
You can print a worksheet, an entire workbook, or any part of a worksheet. You can either print the active sheet (Quick Print) or control exactly what you print using the Print dialog.