How to Fix Excel Table Headers Exporting as TD Tags in PDF
Question details
The user needs to ensure Excel table headers are correctly exported as accessible TH tags rather than generic TD tags when saving a workbook to a PDF document.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Exporting or saving an Excel workbook to a PDF document while attempting to retain accessibility tags for screen readers.
- Observed behavior
- Excel exports table header cells as generic TD tags instead of the required TH tags, and using the 'Print to PDF' function drops accessibility tagging entirely.
Ensure you have a PDF accessibility editing tool, such as Adobe Acrobat Pro or an advanced PDF editor, installed to inspect and manually adjust PDF structural tags after export.
Use Save As PDF with Accessibility and Reflow Options
Printing to PDF strips accessibility tags entirely. Use the built-in export feature to retain document structure, even if some manual tag correction is needed later.
To ensure that your document structure transfers over to the PDF format, you must avoid the 'Print to PDF' method. Instead, you need to use the 'Save As' feature and explicitly enable the generation of structural tags.
Go to File > Save As and select PDF from the file format dropdown menu.
Click on the 'Options...' button located below the file format selection before saving.
Check the box next to 'Document structure tags for accessibility' and click OK.
Click 'Save' to export the file, then open the resulting PDF in your accessibility editor to verify that tags were created.
Manually Correct TD to TH Tags in a PDF Editor
Since Excel defaults to TD tags for all cells, you must manually define the header scope in a dedicated PDF accessibility tool like Adobe Acrobat.
Export Spreadsheets to PDF with WPS Office
WPS Office provides robust, built-in PDF conversion tools, allowing you to easily convert spreadsheets to high-quality PDFs while maintaining layout, formatting, and structural integrity.
- 1. Open your file: Launch WPS Spreadsheets and open the workbook you want to convert.
- 2. Select Export to PDF: Go to the 'Menu' button in the top left corner and select 'Export to PDF'.
- 3. Configure and export: Review your export settings, choose your save location, and click 'Export' to generate a properly formatted PDF.
Frequently Asked Questions
Why does 'Print to PDF' remove accessibility tags?
Printing to PDF effectively 'flattens' the document into an image-like format specifically designed for physical printers. This process discards the structural meta-data and HTML-like tags required for screen readers and accessibility tools.
Can I force Excel to recognize TH tags automatically?
Currently, Excel does not reliably map table headers to PDF <TH> tags during export. The standard workaround requires exporting with accessibility tags enabled and manually adjusting the specific TD tags to TH tags in a PDF editor afterward.
What is the difference between TD and TH tags in a PDF?
A <TD> (Table Data) tag represents a standard cell containing regular data, whereas a <TH> (Table Header) tag identifies a cell as a header. Screen readers rely on <TH> tags to associate data cells with their respective row or column labels for visually impaired users.
Do I need Adobe Acrobat to fix PDF tags?
While Adobe Acrobat Pro is the industry standard for editing PDF accessibility tags, you can use any advanced PDF editor that supports manual tag manipulation to convert TD to TH tags and update table scopes.
