For properly displaying pivot table column labels vertically in Excel, it is recommended to:

1. Select the entire table
2. Choose Formats > Format Selection > Column Labels in Rows
3. Choose Formats > Format Selection > Autofit Column Widths
4. Verify the auto-rotation of column labels is enabled
5. Save and close the worksheet