Soumik Dutta
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.
- 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.
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.
Read More: How to Repeat Rows at Top of Specific Pages in Excel
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.
- You will notice that the second page will get those three rows at the top of that page.
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.
Read More: How to Repeat Rows in Excel When Printing (3 Effective Ways)
Similar Readings
- How to Make a Pattern Repeat in Excel (8 Easy Ways)
- How to Select Column A as Titles to Repeat on Each Page
- [Fixed!] Excel Rows to Repeat at Top Feature Greyed Out
- How to Repeat Rows in Excel at Bottom (5 Easy Ways)
- How to Autofill in Excel with Repeated Sequential Numbers
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.
- 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.
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.
Read More: How to Set Print Titles to Repeat in Excel (2 Examples)
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.
- 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.
- A new dialog box called Macro will appear. Select Rows_to_Repeat_at_Top.
- Click on the Run button to run this code.
- 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.
- Now, if you open the Rows to Repeat.pdf file, you will see rows 2:4 are showing on the second page.
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.
- 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.
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.
Read More: How to Repeat Header Row When Scrolling in Excel (6 Ways)
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!
Related Articles
- How to Repeat Cell Values in Excel (6 Quick Methods)
- Repeat Formula for Each Row in Excel (7 Easy Ways)
- How to Repeat Cell Value X Times in Excel (6 Easy Methods)
- Repeat Formula in Every nth Row in Excel (2 Easy Ways)
- How to Repeat Rows in Excel Based on Cell Value (4 Easy Ways)
- How to Repeat Multiple Rows in Excel (4 Effective Ways)
