How to Set Print Titles in Excel (2 Methods)

Get FREE Advanced Excel Exercises with Solutions!

If you want to Set Print Titles in Excel, this article is for you. Here we will demonstrate to you two simple and easy methods so that you can set print titles in Excel.


How to Set Print Titles in Excel: 2 Easy Methods

The following table contains students’ Name and their scores in different subjects. We want to print this table, and for this table, we want to Set Print Titles in Excel. Here, we will set print titles using 2 methods. We used Excel 365 for this purpose, you can use any available Excel version.

How to Set Print Titles in Excel

Here, to provide you a complete view of our data we have hidden a few rows and narrowed down the column width (this may disturb the view, please ignore it).


Method-1: Set Row as Print Titles on Every Page

When we type Ctrl+P on our worksheet, a print page arrives along with the preview of the page.

Here, in the following picture, we can see the preview of page 1. On this page, we can see the row titles.

However, on the second (2nd) page, there is no row title.

➤ To set the row as the print title on every page, first of all, we have to go to the Page Layout tab in the ribbon.

➤ And we have to select Print Titles.

A Page Setup window will appear.

We will give a print area in the Print area box. Here, we selected our table as the print title area.

➤ After that, as we want Row 2 to repeat at the top, we select that row in the Rows to repeat at top box.

➤ Now, we will click on Print Preview to see the preview.

Finally, we can see the row titles on the second page.

How to Set Print Titles in Excel

Read More: How to Set Print Titles to Repeat in Excel


Method-2: Set Column as Print Titles on Every Page

In this method, we will set the Name as column title on every page.

Here, we can see that there is no Name as the column title on page 3.

How to Set Print Titles in Excel

➤ To set a column title, first, we have to go to the Page Layout tab in the ribbon.

➤ After that, we will select Print Titles.

A Page Setup window will appear.

➤ We will provide Column B (Excel may include the entire data range as it did in our case) in the Column to repeat at left box.

➤ Then, we will click on Print Preview.

Finally, we can see in the preview that on page 3, there is Name as the column title. We will see the Name column on other pages as well.

How to Set Print Titles in Excel

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


Download Workbook


Conclusion

Here, we tried to show you some simple and easy methods that will help you to Set Print Titles in Excel. We hope you will find this article helpful. If you have any queries or suggestions, please feel free to contact us in the comment section.


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.
Afia Kona
Afia Kona

Afia Aziz Kona, a graduate of Civil Engineering from Khulna University of Engineering & Technology, Bangladesh, serves as a technical content creator in the ExcelDemy project. Possessing a passion for innovation and critical thinking, she actively embraces challenges. Beyond her engineering background, Afia exhibits a keen interest in Excel, having authored numerous articles on Excel & VBA-related issues to simplify the experience for users facing obstacles in Excel. Apart from creating Excel tutorials, she is also... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo