How to Set a Row as Print Titles in Excel (4 Methods)

If you are looking for some special tricks to set a row as print titles in Excel, you’ve come to the right place. In Microsoft Excel, there are numerous ways to set a row as print titles. In this article, we’ll discuss four methods to set a row as print titles. Let’s follow the complete guide to learn all of this.


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


4 Methods to Set a Row as Print Titles in Excel

Here, we have a dataset that represents the businessman, items, and sales of New York state. Our main goal is to set a row of print titles on every page.

In the following section, we will use 4 methods to set a row of print titles on every page.


1. Using Print Titles Option to Set a Row as Print Titles

You have to follow the following steps to set a row as print titles using the Print Titles feature.

📌 Steps:

  • Firstly, go to the Page Layout tab and select Print Titles.

Using Print Titles Feature to Set a Row as Print Titles

  • When the Page Setup dialogue box opens, select the Print area and type B2:D46 and you have to select row 4 in the option Rows to repeat at top. Click on Print Preview.

Using Print Titles Feature to Set a Row as Print Titles

  • Next, you have to select Landscape Orientation and as page size select A5 under the Settings.

Using Print Titles Feature to Set a Row as Print Titles

  • Finally, in three pages you will get the Titles in Print preview.

  • On page 2, you will find the remaining data.

Using Print Titles Feature to Set a Row as Print Titles

  • There is more information on page 3.

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


2. Freeze Panes Feature to Set a Row as Print Titles in Excel

You have to use the following steps to set row as print titles on every page by using Freeze Panes feature. In Excel, Freeze Panes keep rows and columns visible while the rest of the worksheet scrolls.

📌 Steps:

  • Firstly, select the row directly below the row you wish to freeze.

Freeze Panes Feature to Set a Row as Print Titles in Excel

  • Next, go to the View tab and select Freeze Panes.

Freeze Panes Feature to Set a Row as Print Titles in Excel

  • No matter how far you scroll down, you will see your desired rows.

  • Here are the remaining data with titles.

  • Now, go to the Page Layout tab and select Print Titles.

Freeze Panes Feature to Set a Row as Print Titles in Excel

  • When the Page Setup dialogue box opens, select the Print area and type B2:D46 and you have to select row 4 in the option Rows to repeat at top. Click on Print Preview.

  • Next, you have to select Landscape Orientation and as page size select A5 under the Settings.

Freeze Panes Feature to Set a Row as Print Titles in Excel

  • Finally, in three pages you will get the Titles in Print Preview.

  • On page 2, you will find the remaining data.

Freeze Panes Feature to Set a Row as Print Titles in Excel

  • There is more information on page 3.

Freeze Panes Feature to Set a Row as Print Titles in Excel

Read More: Print Titles in Excel Is Disabled, How to Enable It?


Similar Readings:


3. Using Subtotal Feature to Set a Row as Print Titles

It is sometimes necessary to print titles in Excel following a common group of names. In order to print titles on every page, we will be using the Subtotal feature. You have to follow the following steps to set a row as print titles using the Subtotal feature.

Using Subtotal Feature to Set a Row as Print Titles

📌 Steps:

  • Start by selecting a range of cells.

  • Next, go to the Home tab, select the Sort & Filter And click on Sort A to Z

Using Subtotal Feature to Set a Row as Print Titles

  • The following output will appear after sorting the name.

  • Then, go to the Data tab. Under the Outline group, select the Subtotal feature.

Using Subtotal Feature to Set a Row as Print Titles

  • When the Subtotal dialogue box opens, select the Count in “Use function”, and check Page break between groups and click on OK.

  • After that, you will get the following output.

Using Subtotal Feature to Set a Row as Print Titles

  • Now, go to the Page Layout tab and select Print Titles.

  • When the Page Setup dialogue box opens, select the Print area and type B2:D12 and you have to select row 4 in the option Rows to repeat at top. Click on Print Preview.

Using Subtotal Feature to Set a Row as Print Titles

  • Next, you have to select Landscape Orientation and as page size select A5 under the Settings.

Using Subtotal Feature to Set a Row as Print Titles

  • Finally, you can view the Titles in Print preview on both pages.

  • On page 2, you will find the remaining data.

Using Subtotal Feature to Set a Row as Print Titles

Read More: [Fixed!] Print Titles Must Be Contiguous and Complete Rows or Columns


4. Excel VBA to Set a Row as Print Titles

Now, we will use VBA code to set a row as print tiles in Excel.

📌 Steps:

  • Firstly, press ALT+F11 or you have to go to the tab Developer, select Visual Basic to open Visual Basic Editor, and click Insert, select Module.

  • Next, you have to type the following code
Sub Printtitles()
Dim VBA As Worksheet
Dim VBA2 As Worksheet
Dim ws As Sheets
Set ws = ActiveWorkbook.Worksheets
Set VBA2 = ws(1)
For Each VBA In ws
VBA.PageSetup.PrintTitleRows = VBA2.PageSetup.PrintTitleRows
Next VBA
End Sub
  • After that, close the Visual Basic window And press ALT+F8.
  • When the Macro dialogue box opens, Select Printtiles in the Macro name. Click on Run.

Excel VBA to Set a Row as Print Titles

  • Finally, you will get the following output.

Read More: How to Remove Print Titles in Excel (3 Methods)


Conclusion

That’s the end of today’s session. I strongly believe that from now you may set a row as print titles in Excel. If you have any queries or recommendations, please share them in the comments section below.

Don’t forget to check our website Exceldemy.com for various Excel-related problems and solutions. Keep learning new methods and keep growing!


Related Articles

Saquib

Saquib

Welcome to my Profile. I am working on and researching Microsoft Excel right now, and I will be posting articles about it here. I received a B.Sc. in Naval Architecture and Marine Engineering from the Bangladesh University of Engineering and Technology (BUET). Having studied naval architecture, I have a strong interest in research and development. Always try to learn from different sources and come up with creative solutions.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo