How do I repeat top rows when printing in Excel 2013?

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?

nguyen's answer

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.

repeat top rows printing excel 2013, without repeat top rows

 

Now go directly to your Excel file, choose the “PAGE LAYOUT” tab of Ribbon bar then click on “Print Titles”.

repeat top rows printing excel 2013, 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.

repeat top rows printing excel 2013, page setup

 

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.

repeat top rows printing excel 2013, choose rows

 

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.

 

repeat top rows printing excel 2013, page setup after choosing

 

It’s here, Excel do repeat top rows across the printing pages.

repeat top rows printing excel 2013, result

 

When you printing with your own worksheet, the result will be the same like this. Good luck!

Advertisement:
Let's stay in touch!
Sign up here and you'll receive even more tech and gadget help right to your inbox, along with exclusive news and industry updates.
Category: Microsoft Office   (Answered Hai Nguyen)
Tag: , ,
Previous:
Next:
2 comments on “How do I repeat top rows when printing in Excel 2013?
  1. Dollie says:

    hello there and thank you for your info – I have definitely picked up anything new
    from right here. I did however expertise several technical
    points using this web site, since I experienced to
    reload the site a lot of times previous to I could get it to load correctly.
    I had been wondering if your hosting is OK? Not that I’m complaining, but slow loading instances times will sometimes affect your placement in google and could damage your high quality score if ads and marketing with Adwords. Anyway I am adding this RSS to my e-mail and can look out for much more of your respective fascinating content. Make sure you update this again very soon.

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>