how to print vertical text in c#

I've got 34 columns and several hundred rows of data. The data used to be presented on spreadsheets using columns headings as descriptive titles for the data. To transpose things would give it a rather unusual view.

(My assumption is that when you use the term "row header" you're suggesting putting all the headings down the left side of the DataGridView table.)

Many of the column headings have fairly long words so even with word wrapping the columns end up being unnecessarily wide.

This was no problem in Excel since the title cell text could be aligned vertically.

So, ideally I would like to put vertical text in the column headers - just like the spreadsheets.

As an old spreadsheet guy I've never used DataGridView before to display data. Perhaps I'm missing something very fundermental here.

Hope I've explained my problem better, and hopefully there's a simple solution.

Anyway to adjust the header automatically ?? as my header is dynamic generate during runtime and i cant perdict the the total character