Using Excel to make a examination table

The A1 – G1 merge cells, in which to write words on end, and the character spacing to be consistent, how to set? Help please help, thank you!

A1-A10 will merge cells vertically and write, such as “personnel management” how to write words, following a map, please help, urgently, thank you!

Right – Format Cells – Alignment, choose the direction of vertical text

Many thanks for your help!

Insert vertical text box, center the middle

can go to my room to find my contact, I can get

right – Format Cells – Alignment, choose the direction of vertical text