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

Get FREE Advanced Excel Exercises with Solutions!

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 2 cases.


How to Set Print Titles to Repeat in Excel: 2 Examples

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 2 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 version 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 Titles Setting Row Titles to Repeat as Print Titles Setting Row Titles to Repeat as Print Titles Setting Row Titles to Repeat as Print Titles Setting Row Titles to Repeat as Print Titles Setting Row Titles to Repeat as Print Titles Setting Row Titles to Repeat as Print Titles Setting Row Titles to Repeat as Print Titles Setting Row Titles to Repeat as Print Titles

Read More: How to Set Multiple Rows as Print Titles in Excel


💡 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


Download Practice Workbook

You can download the practice workbook from the link below.


Conclusion

Last but not least, I hope you found what you were looking for in this article. If you have any queries, please drop a comment below.


Related Articles


<< Go Back to Print Titles | Page Setup | Print in Excel | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Sowmik Chowdhury
Sowmik Chowdhury

Sowmik Chowdhuri, with a BSc in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, serves as a crucial Excel & VBA Content Developer at ExcelDemy. His profound passion for research and innovation seamlessly aligns with his unwavering dedication to Excel. In this role, Sowmik not only skillfully addresses challenging issues but also demonstrates enthusiasm and expertise in gracefully navigating intricate situations, highlighting his steadfast commitment to consistently deliver content of exceptional quality and value. Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo