Rows To Repeat At Top. I would suggest using the print titles button on the page layout tab in the ribbon to make the neessary changes. Row to repeat at top adalah salah satu fungsi dalam microsoft excel yang kita gunakan untuk melakukan pengulangan pada baris.
Click the page layout tab. The option rows to repeat at top is greyed out when you access the page setup dialog from file print page setup. I am using excel in office 365.
To expand the page setup dialog box click the collapse dialog button again.
Click the row number of the row that you want to repeat which will populate the rows to repeat at top field such as in the image below. There can be one to many pages to be printed. Viewed 10k times 3 i am trying to get the first 4 rows of an xlsx file to repeat at the top of each page when printed. In the table properties dialog under row tab check repeat as header row at the top of each page option.