For properly displaying pivot table column labels vertically in Excel, it is recommended to:
- Select the entire table
- Choose Formats > Format Selection > Column Labels in Rows
- Choose Formats > Format Selection > Autofit Column Widths
- Verify the auto-rotation of column labels is enabled
- Save and close the worksheet