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

Get FREE Advanced Excel Exercises with Solutions!

Wouldn’t it be great to have the Titles at the top of every page when printing in Excel? With this in mind, this article demonstrates how to set multiple rows as Print Titles in Excel.


How to Set Multiple Rows as Print Titles in Excel: 4 Simple Ways

Let’s say, we have the Quarterly Salary of the Sales Representatives. Here, we want to print the headers’ Names, Locations, and Quarterly Salaries at the top of every page. So, without further delay, let’s see the methods one by one.

Dataset

Dataset

Dataset

We have used Microsoft Excel 365 version here, you can use any other versions according to your convenience.


Method-1: Using Print Titles Option to Set Multiple Rows as Print Titles

For our first method, we’ll use the Print Titles option to print the headers at the top of each page.

Steps:

  • Firstly, go to the Page Layout tab >> click the Print Titles option in the Page Setup group.

How to Set Multiple Rows as Print Titles in Excel Using Print Titles

After completing this step, the Page Setup wizard appears.

  • Next, click the arrow next to the Rows to repeat at top box.

How to Set Multiple Rows as Print Titles in Excel Using Print Titles

  • Then, hold the CTRL key on your keyboard and select the header rows. In this case, we chose the $4:$5 rows as the headers.
  • After this, press the OK button.

How to Set Multiple Rows as Print Titles in Excel Using Print Titles

  • Now, use the CTRL + P shortcut to open the Print option.
  • Following this, click the arrow at the bottom to go to the next page.

How to Set Multiple Rows as Print Titles in Excel Using Print Titles

The preview for the second page should look like the image shown below.

How to Set Multiple Rows as Print Titles in Excel Using Print Titles

That’s it you’ve placed the headers at the top of every page. It’s that simple!

Read More: How to Set a Row as Print Titles in Excel


Method-2: Applying Keyboard Shortcut

Now, I know what you’re thinking. Are there any shortcut keys? Lucky you! There are shortcut keys for setting Print Titles. And our second method describes just that.

Steps:

  • Firstly, press the ALT key on your keyboard followed by P.

The Ribbon at the top should look like the picture shown below.

How to Set Multiple Rows as Print Titles in Excel Applying Shortcut

  • Afterward, press S and then P on the keyboard. In an instant, the Page Setup dialog box pops up.
  • Next, click the Sheet tab >> select the cell reference of the header rows ($4:$5) >> click on OK.

How to Set Multiple Rows as Print Titles in Excel Applying Shortcut

  • Then, press the CTRL + P keys to go to the Print option.
  • Lastly, use the arrow button to examine the preview pages.

How to Set Multiple Rows as Print Titles in Excel Applying Shortcut

Finally, you’ll see the results as shown in the screenshot below.

How to Set Multiple Rows as Print Titles in Excel Applying Shortcut

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

Method-3: Set Multiple Rows as Print Titles in Excel from File Tab

For our third method, we’ll utilize the File tab to insert Print Titles. So, let’s see it in action.

Steps:

  • Firstly, navigate to the File tab at the top-left corner of the Ribbon.

How to Set Multiple Rows as Print Titles in Excel Using File Tab

  • Next, select the Print option >> then, click on the Page Setup button.

How to Set Multiple Rows as Print Titles in Excel Using File Tab

  • Now, in the Page Setup wizard, move to the Sheet tab >> enter the reference $4:$5 for the titles >> click the OK button.

How to Set Multiple Rows as Print Titles in Excel Using File Tab

  • Lastly, check the preview pages using the arrow key at the bottom.

How to Set Multiple Rows as Print Titles in Excel Using File Tab

The second page of the worksheet looks like the image shown below.

How to Set Multiple Rows as Print Titles in Excel Using File Tab

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


Method-4: Utilizing Freeze Pane Option to Set Multiple Rows as Print Titles in Excel

Excel’s Freeze Panes option allows us to see the column headers even if we scroll down. In this method, we’ll apply the Freeze Panes feature to insert the Print Titles at the top of each page when printing. So, follow these simple steps.

Steps:

  • Firstly, select the row before which you want to freeze. In this case, Row 6 is selected.
  • Secondly, move to the View tab >> click the Freeze Panes drop-down in the Window section.

Freeze Pane

  • Following this, choose the Freeze Panes option from the list.

How to Set Multiple Rows as Print Titles in Excel Using Freeze Pane

This inserts a grey line in between Rows 5 and 6. This means the top 5 Rows will stay in place even if we scroll down.

How to Set Multiple Rows as Print Titles in Excel Using Freeze Pane

  • Thirdly, press CTRL + P to open the Print option. Here, you can examine the preview pages before printing.

How to Set Multiple Rows as Print Titles in Excel Using Freeze Pane

This is the second page of the worksheet.

How to Set Multiple Rows as Print Titles in Excel Using Freeze Pane


Set Multiple Rows as Print Titles in Google Sheets

So far we’ve discussed how to set multiple rows as Print Titles in Excel. However, you can also set Print Titles using Google Sheets. It’s simple & easy, just follow along.

Steps:

  • Firstly, select the cell before which you want to freeze. In this case, we chose the B5 cell.
  • Secondly, go to the View tab.

How to Set Multiple Rows as Print Titles in Google Sheets Using Freeze Pane

  • Next, from the Freeze drop-down select the option Up to row 5.

How to Set Multiple Rows as Print Titles in Google Sheets Using Freeze Pane

Immediately a grey line appears which indicates the top 5 Rows are now frozen.

How to Set Multiple Rows as Print Titles in Google Sheets Using Freeze Pane

  • Thirdly, press the CTRL + P shortcut on your keyboard to open the Print option.
  • Now, click the Headers and footers dropdown.

Using Freeze Pane

  • Following this, insert a check on the Repeat frozen rows box.

Using Freeze Pane

  • Finally, check the preview using the scroll wheel.

Using Freeze Pane

The image below represents the second page of the preview.

Using Freeze Pane


Practice Section

For doing practice by yourself we have provided a Practice section like below in each sheet on the right side. Please do it by yourself.

Practice Section


Download Practice Workbook

You can download the practice workbook from the link below.


Conclusion

This article provides quick and easy answers to how to set multiple rows as Print Titles in Excel. Make sure to download the practice files. Hope you found it helpful. Please inform us in the comment section about your experience.


Related Articles

Eshrak Kader
Eshrak Kader

Hello! Welcome to my Profile. I completed my BSc. at Bangladesh University of Engineering & Technology from the Department of Naval Architecture & Marine Engineering. Currently, I am conducting research & posting articles related to Microsoft Excel. I am passionate about research & development and finding innovative solutions to problems.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo