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

In many cases, when you have a worksheet with lots of data, you might need to set print titles to repeat. In Microsoft Excel, you can do so within seconds. This will help you have titles for all the pages you print. This article demonstrates how to set print titles to repeat in Excel with two cases.


Download Practice Workbook

You can download the practice workbook from the link below.


2 Examples to Set Print Titles to Repeat in Excel

Let’s assume you have a dataset where you have a lot of data under some titles. Now, when you want to print them the preview shows that the titles only come on the first page and not on other pages. So, you want to repeat those titles for other pages also.
In the following stages of this article, I will show you two examples to set print titles to repeat in Excel. One method will set the column titles to repeat and the other will set the row titles to repeat.
We have used Microsoft Excel 365 version for this article, you can use any other versions according to your convenience.


1. Setting Column Titles to Repeat in Excel

In this example, we will see how to set the column titles to repeat in Excel. As you can see in the following screenshot, there is a lot of data in separate columns. If you open the workbook provided, you will find data up to Week 47 which is not visible here (in the following image we have illustrated our dataset up to Week 16). So, now to repeat the column titles while printing follow the below steps.

Setting Column Titles to Repeat in Excel

Steps:

  • First, go to the tab Page Layout from the top of the screen.
  • Next, select Print Titles.

Setting Column Titles to Repeat in Excel

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

Setting Column Titles

  • Then, select row $2:$5 which are the titles in this case.

Setting Column Titles

  • Consequently, click on OK.

Setting Column Titles

At this point, you can go to Print Preview and see your desired result.

  • Right now, press CTRL + P to view the Print Preview.
  • The first page of your print preview will be as shown in the below screenshot.

Setting Column Titles

  • Next, if you navigate to the second page, you will have a preview as shown in the below screenshot.

Setting Column Titles

Read More: How to Select Column A as Titles to Repeat on Each Page


2. Setting Row Titles to Repeat as Print Titles

In this example, we will see how to set the row titles to repeat in Excel. Now, suppose you have a dataset where the rows contain a lot of data. Here, we have shown our dataset up to Week 7 but this dataset contains data up to Week 47 on the right side of this worksheet. So, there will be a lot of pages while printing the worksheet. At this point, to repeat the row titles for all the pages follow the below steps.

Setting Row Titles to Repeat as Print Titles

Steps:

  • At the very beginning, go to the tab Page Layout from the top of the screen.
  • Next, select Print Titles.

Setting Row Titles to Repeat as Print Titles

  • Now, go to Columns to repeat at left and enter column $B:$C.
  • Then, press OK.

Setting Row Titles to Repeat as Print Titles

At this point, you can go to Print Preview and see your desired result.

  • Right now, press CTRL + P to view the Print Preview.
  • The first page of your print preview will be as shown in the below screenshot.

Setting Row Titles to Repeat as Print Titles

  • Finally, if you navigate to the next pages, you will have a preview as shown in the below screenshots.

Setting Row Titles to Repeat as Print TitlesSetting Row Titles to Repeat as Print TitlesSetting Row Titles to Repeat as Print TitlesSetting Row Titles to Repeat as Print TitlesSetting Row Titles to Repeat as Print TitlesSetting Row Titles to Repeat as Print TitlesSetting Row Titles to Repeat as Print TitlesSetting Row Titles to Repeat as Print TitlesSetting Row Titles to Repeat as Print Titles

Read More: How to Set Multiple Rows as Print Titles in Excel (4 Handy Ways)


💡 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.
  • Also, you can set both column and row titles to repeat together for every page.
  • Check the print preview carefully before printing.

Practice Section

For doing practice by yourself we have provided a Practice section like below in another worksheet. Please do it by yourself.

Practice Section


Conclusion

Last but not the least, I hope you found what you were looking for from this article. If you have any queries, please drop a comment below. Also, if you want to read more articles like this, you can visit our website ExcelDemy.


Related Articles

Sowmik Chowdhury
We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo