'%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 Add a Title to an Excel Sheet for Printing or PDF Export
Question details
The user needs to add a title to an Excel worksheet so that it appears consistently at the top of the page when printed or exported as a PDF.
- Product
- Excel
- Device & OS
- not provided
- Scenario
- Preparing an Excel worksheet for physical printing or exporting to a PDF document.
- Observed behavior
- New worksheets do not automatically include titles in the print preview or PDF export, requiring manual configuration of page headers.
Ensure your worksheet data is finalized and consider switching to the Page Layout view so you can clearly see headers and footers as you edit them.
Configure Title Using Print Titles Settings
The most reliable way to add a printed title is by configuring a header through the Page Setup dialog.
By using the Page Layout menu, you can access the dedicated Header/Footer settings to ensure your title appears exactly where you want it on every printed page or PDF.
Open your Excel workbook and click on the 'Page Layout' tab in the top ribbon.
Click on 'Print Titles' to open the Page Setup dialog box.
Navigate to the 'Header/Footer' tab. Choose a pre-set header from the dropdown (such as the sheet name) or click 'Custom Header' to type your own title.
Click 'OK' to save your settings. Go to File > Print to check the Print Preview and ensure the title displays correctly.
Insert a Title via the Header & Footer Option
You can directly insert a header to act as your printed title using the Insert menu.
Easily Configure Print Titles and Export PDFs with WPS Office
WPS Spreadsheet makes it simple to add headers, footers, and print titles. You can perfectly format your worksheets for printing or high-quality PDF export with an intuitive, user-friendly interface.
- 1. Open Your Document: Launch WPS Office and open your spreadsheet file.
- 2. Navigate to Page Layout: Go to the Page Layout tab on the ribbon and click on Print Titles.
- 3. Set Header/Footer: Select the Header/Footer tab to customize the title that will appear on your printed pages.
- 4. Print or Export: Click Menu > Print to preview your document, or select Export to PDF to save a digital copy with your new title.
Frequently Asked Questions
Why can't I see my title in the normal spreadsheet view?
Titles added as headers or footers do not appear in the standard Normal view to keep the workspace uncluttered. To view them, navigate to the View tab and select Page Layout, or check the Print Preview.
How do I repeat row headers on every printed page instead of a page title?
If you want to repeat specific rows containing column labels, go to Page Layout > Print Titles. In the Sheet tab, click the 'Rows to repeat at top' field and select the rows you want to appear on every page.
Can I use the sheet name automatically as the printed title?
Yes. When configuring your custom header in the Page Setup dialog, you can click the 'Insert Sheet Name' icon (which inserts the &[Tab] code) to automatically display the current worksheet's name as the title.
