Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

How to repeatedly print titles in multiple sheets?

To print the header row at top repeatedly in each page is usually used in our working, but have you ever tried to print title rows repeatedly in multiple sheets? In this article, I have two easy ways to handle this question in Excel.

Print titles repeatedly in multiple worksheets with VBA

Print titles repeatedly in multiple worksheets with Kutools for Excelgood idea3

Enable you to do smarter, faster and better

Kutools - the best office productivity tool brings 300 advanced features to Excel. Details... Download...

Office Tab - brings tabbed interface to Excel and Word, make your work much easier. Details...Download...


Print titles repeatedly in multiple worksheets with VBA


There is no built-in feature to repeatedly print titles in multiple sheets, but you can use a macro to handle it.

1. Activate the first sheet in your workbook, click the anchor at the bottom-right corner of Page Setup group on the Page Layout tab. See screenshot:
doc reeatedly print title across sheets 1

2. In the Page Setup dialog, click Sheet tab, select the title row you want to repeatedly print from Rows to repeat at top, and click OK. See screenshot:
doc reeatedly print title across sheets 2

3. Press Alt + F11 keys to enable the Microsoft Visual Basic for Applications window, click Insert > Module to create a new Module.
doc reeatedly print title across sheets 3

4. Then paste below code to the blank script, and press F5 to run the code.

VBA: Repeatedly print titles in multiple sheets

Sub SetAttributes()
'UpdatebyExtendoffice20170810
    Dim xSheet As Worksheet
    Dim xSheetOne As Worksheet
    Dim xSheets As Sheets
    Set xSheets = ActiveWorkbook.Worksheets
    Set xSheetOne = xSheets(1)
    For Each xSheet In xSheets
        xSheet.PageSetup.PrintTitleRows = xSheetOne.PageSetup.PrintTitleRows
    Next xSheet
End 

 

doc reeatedly print title across sheets 4

After applying the VBA, the top row in each sheet will be repeated at top of corresponding sheet while printing.


Print titles repeatedly in multiple worksheets with Kutools for Excel

If you have installed Kutools for Excel, you can apply its Copy Page Setup to quickly copy all or specific page setup from one sheet to other sheets in a workbook.

Kutools for Excel, with more than 120 handy functions, makes your jobs easier. 

After installing Kutools for Excel, please do as below:(Free Download Kutools for Excel Now!)

1. Select one sheet, for instance, select Sheet1, and click the anchor at the bottom-right corner of Page Setup group on the Page Layout tab. See screenshot:
doc reeatedly print title across sheets 1

2. In the Page Setup dialog, click Sheet tab, and select the titles you want to repeatedly print from Rows to repeat at top. See screenshot:
doc reeatedly print title across sheets 2

3. Click OK, then click Enterprise > Printing > Copy Page Setup. See screenshot:
doc reeatedly print title across sheets 7

4. In the Copy Page Setup dialog, check the sheet names you want to apply the same page setup in Copy to list, then check Rows to repeat at top in the Options list. See screenshot:
doc reeatedly print title across sheets 8

5. Click Ok. Now the top rows have been repeated at the top across multiple sheets while printing.



Excel Productivity Tools

Kutools for Excel - The Best Office Productivity Tool

  • Brings 300 powerful advanced features to Excel, enable you to do smarter, faster and better.
  • No longer need memorizing formulas and VBA codes, give your brain a rest from now on.
  • Become an Excel expert in 3 minutes, Complicated and repeated operations can be done in seconds, 
  • Reduce thousands of keyboard & mouse operations every day, say goodbye to occupational diseases now.
  • 110,000 highly effective people and 300+ world-renowned companies' choice.
  • 60-day full features free trial. 60-day money back guarantees. 2 years of free upgrade and support.

Office Tab - brings tabbed interface to Office, make your work much easier.

  • Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
  • Open and create multiple documents in new tabs of the same window, rather than in new windows.
  • Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.

Be the first to comment.