'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Repeat the First Row on Every Excel PDF Page
Question details
The user needs the first row of an Excel worksheet to appear at the top of every page when exporting to PDF, specifically for a file accessed by multiple staff members on SharePoint.
- Product
- Excel
- Device & OS
- not provided
- Scenario
- Exporting a multi-page Excel worksheet to PDF while retaining the header row on every printed page, without disrupting SharePoint data formatting.
- Observed behavior
- By default, the header row only appears on the first page of the exported PDF. Additionally, some SharePoint checkboxes display as TRUE/FALSE values when the file is downloaded to desktop Excel.
Ensure you have access to the desktop version of Excel, as the online web version does not support modifying the Print Titles feature.
Use Desktop Excel to Configure Print Titles
By modifying the page layout settings in the desktop application, you can force the first row to repeat on every PDF page and save the configuration back to SharePoint.
Online versions of Excel have limited printing configurations. To successfully repeat the top row on exported files, the workbook must be opened in the desktop application where full Page Setup options are available.
Once configured and saved, these print settings will persist even when the file is accessed online via SharePoint.
Access the SharePoint workbook and choose the option to open it in the desktop version of Excel.
Navigate to the 'Page Layout' tab on the top ribbon and click on 'Print Titles' in the Page Setup group.
In the Page Setup dialog box, click inside the 'Rows to repeat at top' field, then select Row 1 on your worksheet.
Click 'OK' to confirm the setting. Go to 'File' > 'Export' > 'Create PDF/XPS Document' to generate your PDF.
Save and close the desktop workbook. The print settings will persist when the workbook is accessed online, and checkbox values should remain unchanged.
Easily Set Print Titles and Export to PDF with WPS Spreadsheet
WPS Spreadsheet provides a seamless and user-friendly way to configure print titles, ensuring your header rows repeat on every page when exporting to PDF. It is highly compatible with Microsoft Excel files and allows quick formatting without complex setups.
- 1. Open Worksheet: Launch WPS Spreadsheet and open your Excel workbook.
- 2. Select Print Titles: Navigate to the 'Page Layout' tab on the top ribbon and click the 'Print Titles' button.
- 3. Configure Header Row: In the 'Rows to repeat at top' field, select the first row of your sheet and click 'OK'.
- 4. Export to PDF: Click the 'Menu' button in the top left corner, select 'Export to PDF', configure your save destination, and export your document.
Frequently Asked Questions
Why can't I find the Print Titles option in Excel Online?
Excel Online has limited page layout and printing features. To set rows to repeat at the top of printed pages, you must open the workbook in the desktop version of Excel, apply the setting, and save it back to the cloud or SharePoint.
Will the repeated row show up while scrolling normally on my screen?
No, the 'Rows to repeat at top' setting only affects printed pages and exported PDFs. To keep the top row visible while scrolling digitally on your screen, you need to use the 'Freeze Panes' feature located under the View tab.
How do I fix SharePoint checkboxes changing to TRUE or FALSE?
Excel checkboxes are often stored natively as TRUE/FALSE values within the database. By opening the workbook in the desktop version of Excel, saving your required print changes, and syncing it back to SharePoint, the original visual Yes/No states are usually preserved without requiring manual edits for each cell.
