Repeat the worksheet title when turning the page in Excel

Show you how to repeat the title of the spreadsheet when you turn the page in Excel. To repeat the worksheet title when moving to the page, follow these steps: Step 1: Go to Page Layout - Page Setup tab - click on the bottom arrow icon: Step 2: Page Setup dialog box

The following article details you how to repeat the table header when you turn the page in Excel 2013.

Picture 1 of Repeat the worksheet title when turning the page in Excel

To repeat the worksheet title when you turn the page, follow these steps:

Step 1: In card Page Layout -> Page Setup -> click on the arrow icon on the bottom:

Picture 2 of Repeat the worksheet title when turning the page in Excel

Step 2: The Page Setup dialog box appears, click the Sheet tab in the Rows to repeat at top section and click the icon to select the headline to be repeated on the top of each page when moving to the new page:

Picture 3 of Repeat the worksheet title when turning the page in Excel

For example, here choose line 6 is the title to repeat.

- You can also select the title column to be repeated when switching to the new page displayed on the left side of the worksheet by selecting the data in Columns to repeat at left.

Step 3: After selecting, choose one of the following options:

- Print: Perform printing always the worksheet.

- Print Preview: Perform print preview before printing.

Picture 4 of Repeat the worksheet title when turning the page in Excel

- For example, when selecting a print preview, the Employee List header line is displayed when going to a new page:

Picture 5 of Repeat the worksheet title when turning the page in Excel

The above is a detailed guide on how to loop the lawij worksheet title on page turning in Excel 2013.

Good luck!

Update 19 May 2020
Category

System

Mac OS X

Hardware

Game

Tech info

Technology

Science

Life

Application

Electric

Program

Mobile