How to Set Print Titles to Repeat in Excel (2 Ways)

Example 1 – Setting Column Titles to Repeat in Excel

The sample dataset contains data up to Week 47 which will come to more than one page when printed (in the following image we have illustrated our dataset up to Week 16). We want to repeat the column titles in the other pages and not just the first page.

Steps:

Go to the tab Page Layout from the top of the screen.
Select Print Titles.

For repeating column titles, go to Rows to repeat at top and click on the arrow symbol beside this box.

Select row $2:$5.

Click on OK.

You can go to Print Preview and see your desired result.

Press CTRL + P to view the Print Preview.

The first page of your print preview will be as shown below.

Navigate to the second page. You will have a preview as shown in the following image.

Example 2 – Setting Row Titles to Repeat as Print Titles

Steps:

Go to the tab Page Layout from the top of the screen.
Select Print Titles.

Go to Columns to repeat at left and enter column $B:$C.
Click OK.

You can go to Print Preview and see your desired result.

Press CTRL + P to view the Print Preview.

The first page of your print preview will be as shown in the image below.

If you navigate to the following pages, you will have a preview as shown in the following image.

Things to Remember

You can only set the titles to repeat for more than one row or column if you have them in consecutive order.
You can set both column and row titles to repeat together for every page.
Check the print preview before printing.

Download Practice Workbook

Set Print Titles to Repeat.xlsx