On the Page Layout tab, in the Page Setup group, click Print Area, and then click Add to Print Area. When you save your workbook, the print area is saved as well.

While Excel does add page breaks automatically (indicated by a dashed line), you can also insert, move, or delete page breaks in a worksheet. If you only need to print a section of your …

In Excel for the web, you can either specify an area you want to print or print an entire worksheet. If you select a print area, but decide to change the specified area, here's how you can preview …

Click Print. Set a print area Excel saves the print area together with the workbook. Select the cells that you want to print. On the File menu, point to Print Area, and then click Set Print Area. On …

By default, Microsoft Excel prints worksheets in portrait orientation (taller than wide). You can change the page orientation to landscape to print it sideways.

When you preview a worksheet in Microsoft Excel, it opens in the Microsoft Office Backstage view. In this view, you can change the page setup and layout before you print.

Print area Click the Print area box to select a worksheet range to print, and then drag through the worksheet areas that you want to print. The Collapse Dialog button at the right end of this box …

When an Excel worksheet spans more than one page, you can print row and column headings (also known as headers or labels) on every page.

In Excel, you can scale a worksheet for printing by shrinking or enlarging its size to better fit the printed pages. You can also scale a worksheet to fit the paper width of printed pages, or …

To better align an Excel worksheet on a printed page, you can change margins, specify custom margins, or center the worksheet—either horizontally or vertically on the page.