HomeApplicationOffice informationRepeat the worksheet title when turning the page in Excel

Repeat the worksheet title when turning the page in Excel

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

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

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:

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

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:

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

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.

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

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

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

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

Good luck!

5 ★ | 1 Vote

You should read it

May be interested

  • Create header and footer in ExcelPhoto of Create header and footer in Excel
    teach you how to create headers and footers in excel. to create the header, the footer follows these steps: step 1: go to page layout - page setup tab - click on the arrow below: step 2: a dialog box appears - click the header tab /
  • Perform printing in ExcelPhoto of Perform printing in Excel
    guide you to perform printing in excel. after setting up the page to print the final step, you can manipulate to print the worksheet in excel. step 1: after setting up the worksheet - click file - print: step 2: the print window appears in pa section
  • Insert and edit charts in ExcelPhoto of Insert and edit charts in Excel
    instructions on how to insert and edit charts in excel. to insert a chart, follow these steps: step 1: select the data to create a chart. the example here wants to create a sales chart of the employees. go to the insert tab - illustration - chart -
  • Create and edit mathematical expressions in ExcelPhoto of Create and edit mathematical expressions in Excel
    show you how to create and edit mathematical expressions in excel. to insert mathematical formulas, you perform the following steps: step 1: go to the insert - text - symbols - equation tab: step 2: the dialog box contains the display formula types - select the formula type
  • Create and edit Textbox in ExcelPhoto of Create and edit Textbox in Excel
    instructions on how to create and edit textbox in excel. to insert textbox you perform the following steps: step 1: go to the insert - text - textbox tab: step 2: drag and move the mouse to create the area for textbox - enter the content to create textbox.
  • Insert and edit Word Art in ExcelPhoto of Insert and edit Word Art in Excel
    instructions on how to insert and edit word art in excel. step 1: go to the insert - text - word art tab - select the type of font you want to create word art: step 2: enter the content to create artistic text.

Office information