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.
- Reuse Anything: Add the most used or complex formulas, charts and anything else to your favorites, and quickly reuse them in the future.
- More than 20 text features: Extract Number from Text String; Extract or Remove Part of Texts; Convert Numbers and Currencies to English Words.
- Merge Tools: Multiple Workbooks and Sheets into One; Merge Multiple Cells/Rows/Columns Without Losing Data; Merge Duplicate Rows and Sum.
- Split Tools: Split Data into Multiple Sheets Based on Value; One Workbook to Multiple Excel, PDF or CSV Files; One Column to Multiple Columns.
- Paste Skipping Hidden/Filtered Rows; Count And Sum by Background Color; Send Personalized Emails to Multiple Recipients in Bulk.
- Super Filter: Create advanced filter schemes and apply to any sheets; Sort by week, day, frequency and more; Filter by bold, formulas, comment...
- More than 300 powerful features; Works with Office 2007-2019 and 365; Supports all languages; Easy deploying in your enterprise or organization.
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:
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:
3. Press Alt + F11 keys to enable the Microsoft Visual Basic for Applications window, click Insert > Module to create a new Module.
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
After applying the VBA, the top row in each sheet will be repeated at top of corresponding sheet while printing.
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:
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:
3. Click OK, then click Enterprise > Printing > Copy Page Setup. See screenshot：
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:
5. Click Ok. Now the top rows have been repeated at the top across multiple sheets while printing.