How to repeat the headline when printing in Excel

The following article shows you how to repeat the headline when printing in Excel 2013.

Step 1: Select the Page Setup tab -> Print Titles .

How to repeat the headline when printing in Excel Picture 1

Step 2: A dialog box appears -> select the data area to print in Print Area , if you want to repeat the subject line, click Rows to repeat at top , if you want to repeat the column, select Columns to repeat at left -> OK .

How to repeat the headline when printing in Excel Picture 2

Note: You can choose the page format and paper size in the Option section.

Select print preview mode ( Print Preview ):

How to repeat the headline when printing in Excel Picture 3

On page number 2 the headline is always displayed at the top of the page.

Hopefully the article above helps you save your time. Good luck!