How to Set Print Areas and Print Titles on a Worksheet

This article will guide you through the process of setting print areas and print titles in a worksheet using Spreadsheets 2013.

If a worksheet contains more than one page, you can print row and column headings or titles on every page to make the page data properly labeled.

Set print area

Step 1 Select the worksheet range that you want to print.

Step 2 Under 2013 style interface of Spreadsheets 2013, go to Page Layout tab, click Print Area. Select Set Print Area.

Figure 1 Set Print Area

Set print titles

Step 1 Select the worksheet range that you want to include titles when print.

Step 2 Under 2013 style interface of Spreadsheets 2013, go to Page Layout tab, click Print Titles.

Step 3 In the Page Setup dialog that pops up, click on the select button in Rows to repeat at top area and select a title row.

Figure 2 Set Print Titles in Page Setup

Figure 3 Select Row(s) to Repeat in Every Page

Step 4 Go back to Page Setup dialog and press OK to finish setting. Now the selected row is repeated at the top of each page. In Print Preview, the pages looks like the following:

Figure 4 Repeated titles on every page of the worksheet

In the same way you can set column(s) to repeat at the left of each page.

Tips:

To show row and column headings, you can tick the check box before Row and column headings under Print in the Page Setup dialog (see Figure 2).