How to Print Titles in Excel (5 Easy Ways)

The Title is present only on the first page when Excel prints a worksheet. This is pretty inconvenient to analyze a long worksheet. To get rid of the problem, this article will show you simple and effective ways to Print Titles on every page in Excel.

To help you understand better, I’m going to use a sample dataset as an example. The following dataset represents the Salesman, Product, and Net Sales of a company.

print titles excel


Download Practice Workbook

Download the following workbook to practice by yourself.


5 Easy Ways to Print Titles in Excel

1. Excel Print Titles Feature to Print Titles

In our first method, we’ll use the Print Titles feature to print titles in Excel.

STEPS:

  • First of all, select the Print Titles feature which you’ll find under the Page Layout tab.

Excel Print Titles Feature to Print Titles

  • A dialogue box will pop out.
  • There, under the Sheets tab, type B2:D10 in the Print area, select row 4 in Rows to repeat at top, and then, press Print Preview.

Excel Print Titles Feature to Print Titles

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

  • Finally, you’ll get to see your desired output.

Read More: How to Print Titles in Excel Except for Last Page (2 Easy Macros)


2. Print Feature for Printing Titles in Excel

Sometimes, we also need to print the Row Headers and Column Numbers in Excel. Follow the steps below to know how to do that.

Print Feature for Printing Titles in Excel

STEPS:

  • Firstly, check the Print option of Headings, which you’ll find in the Sheet Options group under the Page Layout tab.

  • Next, press the ‘Ctrl’ and ‘P’ keys together and see the outcome in the print preview.

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


3. Print Titles with Excel Freeze Panes Feature

In Excel, we can freeze panes so that we can see the titles even if we scroll down. We’ll use the Freeze Panes feature in this method for printing titles.

STEPS:

  • First, select the row which is just under the rows you want to freeze.

Print Titles with Excel Freeze Panes Feature

  • Next, select Freeze Panes in the Freeze Panes drop-down list under the View tab.

Print Titles with Excel Freeze Panes Feature

  • Then, you’ll get to see that your desired rows are still there even if you scroll down.

Print Titles with Excel Freeze Panes Feature

Here is the rest of the data with the title.

Print Titles with Excel Freeze Panes Feature

  • Now, select Print Titles under the Page Layout tab.

Print Titles with Excel Freeze Panes Feature

  • In the pop-up dialogue box, type B2:D20 in the Print area, select 4th Row in Rows to repeat at top, and then, press Print Preview.

  • After that, under the Settings, select Landscape Orientation and A5 as the page size.

  • In the end, both pages will have the Titles in the printing preview.

The rest of the data are on Page 2.

Related Content: [Fixed!] Print Titles Must Be Contiguous and Complete Rows or Columns


Similar Readings


4. Subtotal Feature in Excel for Printing Titles

We may also need to print titles in Excel after a common group of names. Here, we’ll use the Subtotal feature in this method to print titles on every page based on a common name group.

Subtotal Feature in Excel for Printing Titles

STEPS:

  • First of all, select the range of cells to work with.

Subtotal Feature in Excel for Printing Titles

  • Next, select Sort A to Z from the Sort & Filter drop-down list in the Editing group under the Home tab.

Subtotal Feature in Excel for Printing Titles

  • Then, it’ll return the worksheet after sorting the names.

Subtotal Feature in Excel for Printing Titles

  • Now, select the Subtotal feature in the Outline group under the Data tab.

Subtotal Feature in Excel for Printing Titles

  • A dialogue box will pop out.
  • There, select Salesman from ‘at each change in’ list, Count in ‘Use function’, check the Net Sales, and also check the Page break between groups and finally press OK.

Subtotal Feature in Excel for Printing Titles

  • After pressing OK, you’ll get to see your worksheet as it’s shown in the following image.

  • Then, select Print Titles under the Page Layout tab.

  • In the pop-up dialogue box, go to the Sheet tab,
  • There, select your Print area and the desired row in Rows to repeat at the top and then, press Print Preview.

  • Finally, you’ll get to see your required outcome.

From Page 2 data are shown below.

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


5. Excel VBA to Print Title in Multiple Worksheets

Our last method is to use VBA code in Excel to Print Titles in multiple worksheets.

STEPS:

  • First of all, select the Print Titles feature which you’ll find under the Page Layout tab.

Excel VBA to Print Title in Multiple Worksheets

  • Next, select Row 4 in Rows to repeat at top.

Excel VBA to Print Title in Multiple Worksheets

  • Then, select Visual Basic under the Developer tab.

Excel VBA to Print Title in Multiple Worksheets

  • A new window will pop out and there, select Module under the Insert tab.

Excel VBA to Print Title in Multiple Worksheets

  • Another window will pop out and type the code given below in the Module window.
Sub FixAttributes()
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

Excel VBA to Print Title in Multiple Worksheets

  • After that, close the Visual Basic window.
  • Now, open any worksheet you want and select Macros under the Developer tab.

  • A dialogue box will pop out and there, select FixAttributes in the Macro name.
  • Then, press Run.

  • Finally, you’ll get the desired Titles on every page in your worksheets.

Read More: How to Print Excel Spreadsheet on Multiple Pages (3 Ways)


Conclusion

Now you will be able to Print Titles in Excel using the above-described methods. Keep using them and let us know if you have any more ways to do the task. Don’t forget to drop comments, suggestions, or queries if you have any in the comment section below.


Related Articles

Aung

Aung

I'm Aung. Recently I earned my B.Sc. Degree in Electrical and Electronic Engineering. From now on, I will be working in Microsoft Excel and other useful software, and I’ll upload articles related to them. My current goal is to write technical contents for anybody and everybody that will make the learning process of new software and features a happy journey.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo