[Fixed!] Excel Rows to Repeat at Top Not Working (4 Solutions)

When we try to print a large dataset, we need to show the header rows of the table on the top of every page for the convenience of the authorized people. Usually, this feature doesn’t work automatically. In this article, we will show 4 possible solutions to fix the issue, Excel rows to repeat at top not working. If you are also facing the same problem, download our practice workbook and follow us.


Download Practice Workbook

Download this practice workbook for practice while you are reading this article.


4 Possible Solutions If Excel Rows to Repeat at Top Is Not Working

To demonstrate the solutions, we consider a dataset of employee details in the range of cells B5:H66. Now, if we try to print the dataset, you will notice that there is a title and heading on the first page.

However, such a title or table heading is unavailable on the other page. We will show you how to fix this issue and rows to repeat at the top.


Solution 1: Define Row Range in Page Setup from Page Layout Tab

In this method, we will write down the row range in the Page Setup dialog box located in the Page Layout tab to repeat rows at the top. The steps of this process are given below:

📌 Steps:

  • First of all, go to the Page Layout tab.
  • Now, click the Page Setup dialog box launcher.

  • As a result, the Page Setup dialog box will appear.
  • Then, in the Sheet tab, write down your desired row range in the empty box beside the Rows to repeat at top text. We select the $2:$4 rows to show at the top of another page.
  • Finally, click OK.

Excel rows to repeat at top not working

  • After that, press ‘Ctrl+P’ to launch the print preview.
  • You will see that the second page will get those three rows at the top of that page.

Excel rows to repeat at top not working

Thus, we can say that our method worked perfectly, and we are able to fix the problem of Excel rows to repeat at the top not working.


Solution 2: Denote Row Range in Page Setup from Print Preview

In this approach, we are going to launch the Page Setup dialog box from the print preview to repeat rows at the top. The steps of this procedure are given as follows:

📌 Steps:

  • At first, press ‘Ctrl+P’ to launch the print preview.
  • After that, click the Page Setup option.

  • As a result, a small dialog box called the Page Setup will appear.
  • Now, in the Sheet tab, write down your desired row range in the empty box beside the Rows to repeat at top text. We select the $2:$4 rows to show at the top of another page.
  • Finally, click OK.

Excel rows to repeat at top not working

  • You will notice that the second page will get those three rows at the top of that page.

Excel rows to repeat at top not working

Hence, we can say that our method worked effectively, and we are able to fix the problem of Excel rows to repeat at the top not working.


Solution 3: Select Row Range from Print Titles Command

In the following process, we will use the Print Titles command for opening the Page Setup dialog box to repeat rows at the top. The procedure of this method is given below:

📌 Steps:

  • First, in the Page Layout tab, select the Print Titles command from the group Page Setup.

  • A small dialog box entitled the Page Setup will appear.
  • Now, in the Sheet tab, write down your desired row range in the empty box beside the Rows to repeat at top text. We select the $2:$4 rows to show at the top of another page.
  • Finally, click OK.

Excel rows to repeat at top not working

  • Then, press ‘Ctrl+P’ to launch the print preview.
  • You will see that the second page will get those three rows at the top of that page.

Excel rows to repeat at top not working

So, we can say that our method worked successfully, and we are able to fix the problem of Excel rows to repeat at the top not working.


Solution 4: Use VBA Code

Writing a VBA code can also help you to repeat rows at the top. For showing this method, we are using the same datasheet which we have already used. Our dataset is in the range of cells B4:H66. The steps of this process are given as follows:

📌 Steps:

  • To start the approach, go to the Developer tab and click on Visual Basic. If you don’t have that, you have to enable the Developer tab. Or You can also press ‘Alt+F11’ for opening the Visual Basic Editor.

Use VBA Code for Excel Rows to Repeat at Top Not Working

  • A dialog box will appear.
  • Now, in the Insert tab on that box, click Module.

  • Then, write down the following visual code in that empty editor box.

Sub Rows_to_Repeat_at_Top()
Dim Total_Pages As Long
Total_Pages = Application.ExecuteExcel4Macro("GET.DOCUMENT(50)")
With ActiveSheet.PageSetup
.PrintTitleRows = "$2:$4"
ActiveSheet.PrintOut From:=1, To:=Total_Pages
End With
End Sub
  • Close the Editor tab.
  • After that, in the Developer tab, select the Macros option from group Code.

Use VBA Code for Excel Rows to Repeat at Top Not Working

  • A new dialog box called Macro will appear. Select Rows_to_Repeat_at_Top.
  • Click on the Run button to run this code.

Use VBA Code for Excel Rows to Repeat at Top Not Working

  • A new dialog box called Save Print Output As will appear.
  • Choose your desired location and write down a suitable name for the file. In our case, we write Rows to Repeat.
  • Finally, click Save.

Use VBA Code for Excel Rows to Repeat at Top Not Working

  • Now, if you open the Rows to Repeat.pdf file, you will see rows 2:4 are showing on the second page.

Use VBA Code for Excel Rows to Repeat at Top Not Working

Finally, we can say that our visual code worked successfully and we are able to fix the problem of Excel rows to repeat at the top not working.


Excel Rows to Repeat at Top Not Working When Scrolling

In our previous approach, we have shown you the possible ways for Excel rows to repeat at the top when we print the dataset. Now, we are going to show the procedure to keep rows at the top of the Excel spreadsheet. This procedure describes below step-by-step:

📌 Steps:

  • Take the decision of which rows you want to show at the top. We want to keep rows 1:4 for demonstrating the procedure.
  • Afterward, select cell A5.
  • Then, in the View tab, click on the drop-down arrow of the Freeze Panes option from the group Window.
  • Choose the Freeze Panes option.

Fix Excel Rows to Repeat at Top Not Working When Scrolling

  • Now, if you scroll down with your mouse, you will notice that rows 1:4 are remaining at the same position while the other rows are scrolling down.

Fix Excel Rows to Repeat at Top Not Working When Scrolling

At last, we can say that our procedure worked successfully, and we are able to fix Excel rows to repeat at the top not working when scrolling.


Conclusion

That’s the end of this article. I hope that this article will be helpful for you and you will be able to fix the issue of Excel rows to repeat at the top not working. Please share any further queries or recommendations with us in the comments section below if you have any further questions or recommendations.

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

Soumik Dutta
We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo