How to Set Print Titles in Excel (2 Methods)

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.

Download Workbook


2 Methods to Set Print Titles in Excel

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 add the row 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 a Row as Print Titles in Excel (4 Methods)


Similar Readings


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

In this method, we will set the Name as column titles 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: [Fixed!] Print Titles Must Be Contiguous and Complete Rows or Columns


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 know us in the comment section.


Related Articles

Afia

Afia

Hello, I am Afia Aziz Kona. I graduated in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology (BUET). I have an immense interest in technical writing and content development, therefore, I am working as a content developer at Exceldemy. In my spare time, I travel, watch movies, and cook different dishes.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo