I am running Excel 2013. I want to print a long spreadsheet and I would like the top rows repeated on the top of each page. I go to print and go to Page Setup. I select the “Sheet” tab. Under “Print” Titles”, both selections are disabled (grayed); “Rows to Repeat at Top” and Columns to Repeat at Left” are unavailable for selection. Do you know why I cannot access this feature in Excel 2013?
As I have been using Excel since Excel 97, I always set the first row frozen, so that when I scroll through my worksheet on screen, I can differentiate the column information by having the first row frozen. Also I would do repeat these top rows when printing long document so that I do not have to turn my pages back and forward.
In previous versions of Excel, this greying out was the case if you activated “Page Setup” from the “Print Preview” option but not through “File” -> “Page Setup”. However, Microsoft has change the interface of the Office package since Microsoft Office version 2007. In the shuffling of the user interface from 2007 onwards, “File” -> “Print” is effectively the equivalent of the old “Print Preview” and the “Page Setup” option in the “Page Layout” tab the equivalent of the “old” “File” -> “Page Setup”.
By default the option for setting print area, “Rows to repeat” and “columns to repeat” are greyed out if you display the “Page Setup” dialog via the “Print” option. I would suggest using the “Print Titles” button on the “Page Layout” tab in the ribbon to make the necessary changes.
Let’s see my example, I have two pages worksheet. As we can see, without repeating title rows (or top rows) we cannot know what column meaning in the second page.
Now go directly to your Excel file, choose the “PAGE LAYOUT” tab of Ribbon bar then click on “Print Titles”.
Then we will go to Page Setup dialog. Look under the Print titles, you can see “Rows to repeat at top”. That is what you want. Click on the right-side of the input box.
Then you will back to your Excel file will dialog named “Page Setup – Rows to repeat at top:”. Move your mouse to window edge and choose the rows to repeat. Here the range I choose is from first row to seventh row. Then push the “Enter” button.
Now Excel will back to Page Setup dialog. We can see the value we choose is displayed in right place. Click on Preview button to see the result.
It’s here, Excel do repeat top rows across the printing pages.
When you printing with your own worksheet, the result will be the same like this. Good luck!