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.
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.
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.
➤ 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.
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
- How to Set Print Titles to Repeat in Excel
- How to Set Multiple Rows as Print Titles in Excel
- How to Print Titles in Excel Except for Last Page
- How to Remove Print Titles in Excel
- Print Titles in Excel Is Disabled, How to Enable It?
- [Fixed!] Print Titles Must Be Contiguous and Complete Rows or Columns