How to Repeat a Header Row When Printing from Excel on iPad
Question details
The user wants to repeat a header row at the top of every printed page in Excel for iPad, but the Excel iPad app does not include the Page Setup option for repeating print titles.
- Product
- Microsoft Excel for iPad
- Device & OS
- iPadOS
- Scenario
- Printing a multi-page worksheet from Excel on an iPad with a repeated header row on each page.
- Observed behavior
- Excel for iPad has no built-in Page Setup or Rows to repeat at top option, so the header row only prints on the first page.
Confirm the workbook is saved in a cloud location such as OneDrive, iCloud Drive, or a network folder so you can open the same file from a desktop computer or another Office app without losing formatting.
Set repeating print titles in Excel for Mac or Windows
Use this when you have access to a computer. Desktop Excel includes the Page Setup sheet option that Excel for iPad does not currently offer.
Excel for iPad does not expose the Rows to repeat at top setting. Once you set it on a desktop version, the Page Setup information is saved in the workbook, and many print jobs or other apps will respect it.
On a Mac or Windows PC, open the same workbook in Microsoft Excel.
Go to Page Layout > Print Titles, or click File > Print > Page Setup.
On the Sheet tab, click the Rows to repeat at top box, then select row 1 or the header row range such as $1:$1.
Click OK, save the workbook, and re-open it from your cloud or email location on iPad before printing.
Submit a feature request for Excel for iPad
Use this if you want Microsoft to add the missing print-title option to Excel for iPad. Feedback helps the Excel mobile team prioritize this Page Setup feature.
Use WPS Office to Open and Print Excel Workbooks with Header Rows
For a free, lightweight alternative to Microsoft Excel, WPS Office gives you familiar spreadsheet tools, Microsoft Excel format compatibility, and print-title controls in its desktop spreadsheet app. It is a practical option when Excel for iPad does not expose the repeat header row setting.
Frequently Asked Questions
Can I repeat a header row when printing directly from Excel for iPad?
No, Excel for iPad does not currently include the Page Setup option needed to set rows to repeat at top. You need to configure it in Excel for Mac or Windows, or use another spreadsheet app that supports print titles.
Will the repeat header row setting be saved if I set it on a computer?
Yes. When you save the workbook after selecting Rows to repeat at top in desktop Excel, that Page Setup information is saved in the file. Open the updated file from your cloud or email on iPad to print with the saved setting.
Does WPS Office support repeating header rows when printing?
WPS Office Spreadsheet includes page setup and print-title options in its desktop version, allowing you to select a row to repeat at the top of printed pages. The exact availability may vary by platform, so check the print settings in your WPS Office app.
Why does Excel for iPad not show the Print Titles option?
Microsoft has not added the full Page Setup dialog to Excel for iPad. Many mobile versions of Excel offer a simplified print experience that omits advanced options such as rows to repeat at top.
