Fix Excel 2016 PDF Table Headers Tagged as Data Cells
Question details
Correct table headers that are identified as data cells in an accessible PDF exported from Excel 2016.

- Product
- Microsoft Excel 2016 and Adobe Acrobat or Nuance PDF software
- Device & OS
- not provided
- Scenario
- A user exports an Excel table to PDF and checks its accessibility structure.
- Observed behavior
- Acrobat or Nuance identifies some table headers as data cells even though Excel reports no accessibility problems.
Export the workbook to PDF and identify which cells should be row or column headers. Open the PDF in an editor that can inspect and modify accessibility tags, such as Adobe Acrobat Pro.
Change PDF table data cells to header cells in Acrobat
Use Acrobat's table editing tools to correct header cells in the exported PDF.
Excel's accessibility check does not guarantee that every table relationship will be tagged correctly in the exported PDF. Review the PDF structure separately.
In Adobe Acrobat Pro, select File > Open and choose the PDF exported from Excel.
Open the accessibility tools, choose Reading Order, and select Table Editor for the affected table. Tool locations can vary by Acrobat version.
Select an affected cell, right-click it, and choose Table Cell Properties. Set the cell type to Header Cell and choose the appropriate row or column scope.
Repeat for other affected headers, inspect the table in the Tags panel, and save the PDF. Run Acrobat's accessibility check and manually verify the header relationships.

Work with Excel tables and PDFs in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for working with spreadsheets and PDFs. Its format compatibility helps you move existing Office files into your workflow. It does not repair Excel's PDF export tagging issue; use an accessibility-capable PDF editor to verify and correct tags.

Frequently Asked Questions
Why does the PDF have incorrect headers if Excel found no accessibility problems?
Excel checks the workbook, while the exported PDF has its own tag structure. Open the PDF in Acrobat and inspect the table using Reading Order and the Tags panel.
What is the difference between a TH tag and a TD tag?
A TH tag identifies a table header cell; a TD tag identifies a data cell. In Acrobat's Table Editor, use Table Cell Properties to designate a header cell and set its scope.
Should a table header have row or column scope?
Choose column scope when the header describes cells below it, and row scope when it describes cells across the same row. Set this in Acrobat's Table Cell Properties.
Does changing the tags fix the Excel workbook?
No. The changes apply to the PDF you edit. If you export a new PDF from Excel, inspect its table tags again.




